#indexing

2 entries: Note.

September 16, 20267 sections
Sizing a PostgreSQL Queue Table by Its Live Set
On a queue table, an index and an autovacuum threshold that grow with the table scale wrong; the measured case for sizing both to the pending jobs
#postgresql #queue #performance #indexing #production
September 5, 20266 sections
Indexes: Too Few Slow Reads, Too Many Kill Writes
A missing index slows the query; too many indexes make every write expensive. Striking the right balance by measurement, not by guesswork
#postgresql #database #performance #indexing