Latest posts from Louise Grandjonc Leinweber

Hacking the Postgres Statistics Tables for Faster Queries

Postgres does a great job of making queries really efficient. By gathering data in internal statistics tables, Postgres estimates before a query is run lots of things - like will an index scan be better than a sequential scan. How to pull data for the WHERE statement. What Postgres doesn’t know  …. is how your columns are related to each other. Postgres isn’t a machine learning algorithm. It is not going to learn over time as you query things what is related and what isn't. It uses the same stat...