146 karma · joined October 4, 2018
RLS is hard to work with, hard to debug, hard to reason about, cumbersome. It is however powerful.
Botany: Jacob White and Felipe Yamashita, for finding that certain plants imitate the leaf shape of nearby plastic plants and concluding that "plant vision" is plausible.
This somehow doesn't fit the Iq award in my mind.
1. Always use BUFFERS when running an EXPLAIN. It gives some data that may be crucial for the investigation.
2. Always, always try to get an Index Cond (called Index range scan in MySQL) instead of a Filter.
3. Always, always, always assume PostgreSQL and MySQL will behave differently. Because they do.
One issue I experience is that "Virtual Machine Service for Docker" is consistently sitting at 6gb ram. I am running in "linux/amd64" mode as I had some compatibility issues.
Another issue is that for some reason WebStorm sometimes works much worse than on linux which I used before the mac. As if WebStorm completely turns off some features (highlight, typechecking...) from time to time.