< Back to notes

Browse 2 notes tagged query performance.

#query performance

Do not add an index first: use EXPLAIN, statistics, and ANALYZE to see what PostgreSQL is guessing

#PostgreSQL#database#query performance+2

2026-08-31

Indexes follow query shape, not a column checklist

#PostgreSQL#database#index+2

2026-08-28