Tag
releases
Every PostgreSQL database has a few queries the planner gets badly wrong. Not slow because they’re big. Slow because the planner guessed the wrong row count, picked …
benchmarks
The Join Order Benchmark is where query optimizers go to be embarrassed. It’s 113 queries over the IMDB movie database, real data with all its skew and correlated …
testing
A tool that runs your queries on a database has two jobs, and the first one matters more. It must never do harm: no writes, no settings left behind, no runaway query. …
guides
A query optimizer turns your SQL into a plan: which table to read first, which index to use, how to join one table to the next. A learned query optimizer is one that …