When Good Correlation is Not Enough
Haki Benita, on his blog:
How outliers can trick the optimizer into the wrong plan
This blog post is nothing about what I expected it to be:
In this article I describe how using a BRIN index in presumably โideal circumstancesโ can result in degraded performance and suggest a recent new feature of PostgreSQL as a remedy.
Blank stare.
However, the subtitle sent me down a thought rabbit hole about outliner events making you optimize for the wrong thing. Something I hope to write about in the future.