What is autovacuum doing to my temporary tables?
The main issue is that autovacuum does not touch temporary tables. Yes, it’s true – you have to VACUUM temporary tables on your own. Read more
A beginners guide to PostgreSQL's UPDATE and autovacuum
This article is a beginners guide about how PostgreSQL handles UPDATEs, about VACUUM as well as autovacuum and it's limitations.
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.
