Four reasons why VACUUM won't remove dead rows from a table
by
Laurenz Albe |
03.2018Why vacuum? Whenever rows in a PostgreSQL table are updated or deleted, dead rows are left behind. VACUUM gets rid […]
What PostgreSQL Full-Text-Search has to do with VACUUM
What does PostgreSQL Full-Text-Search have to do with VACUUM? Find out about the GIN pending list and how to use it to improve performance.
Speeding up things with hint bits
UPDATED June 2023: What are hint bits in PostgreSQL? Hint bits improve PostgreSQL performance - find out why and how. Includes code examples.
Table bloat revisited: Making tables shrink in PostgreSQL
UPDATED Understand table bloat. Why deleting data from a table in a PostgreSQL database does not always shrink files on disk.
