July 27, 2023

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.


snippets