database

Postgres query slow? When to add an index, and when it makes things worse

An index speeds up reads and taxes every write. Here is when it pays, how to order the columns, and how to read EXPLAIN, using the PostgreSQL docs and our own price table, where five indexes take up more room than the data.

Voltage · 2h ago · 9 min