Note 7 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
All tags
Tag
#indexing
2 entries: Note.
-
-
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