Postgres Vacuum Table. PostgreSQL vacuum is an important topic in PostgreSQL database administration. VACUUM reclaims storage occupied by dead tuples.
In normal PostgreSQL operation tuples that are deleted or obsoleted by an update are not physically removed from their table. Autovacuum_analyze_scale_factor 0 autovacuum_analyze_threshold 5000 autovacuum_vacuum_scale_factor 0 autovacuum_vacuum_threshold 5000 autovacuum_max_workers. Vacuum is the garbage collector of postgres that go through the database and cleanup any data or rows that have been marked for deletion.
VACUUM FULL FREEZE VERBOSE.
In PG13 parallel vacuum is introduced which allows for parallel vacuuming of multiple indexes corresponding to a single table. PostgreSQL 12 Vacuum has come up with an extra option for the table to avoid truncating pages on a busy OLTP system with the vacuum_truncate command. Its job is to make sure that database tables do not get full of deleted rows that would impact the performance of the database. ALTER TABLE In this case we have changed the scale factor and made autovacuum kick in less frequently.
