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


Previous post
Better Contexts, Better Life Some emails generate an increased pulse rate. Not out of excitement โ€” but out of a primal urge to shout out like an enraged monkey. As I breathe-in
Next post
Vivaldi Social Mastodon Social Downtime Incident Thomas Pike, on his blog: A bug in the code combined with an ill-advised database configuration caused 198 user accounts to be merged to a single