🐘 Postgres - Optimising query
Postgres reads data in 8 KB pages. This post explains why one lookup reads 33,333 pages without an index and 4 with one, when the planner skips an index, how to read EXPLAIN, and what SELECT * and LIMIT save.
Postgres reads data in 8 KB pages. This post explains why one lookup reads 33,333 pages without an index and 4 with one, when the planner skips an index, how to read EXPLAIN, and what SELECT * and LIMIT save.