Add vacuum_freeze_table_age GUC option, to control when VACUUM should
Heikki Linnakangas <heikki.linnakangas@iki.fi>
Add vacuum_freeze_table_age GUC option, to control when VACUUM should ignore the visibility map and scan the whole table, to advance relfrozenxid.
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/catalogs.sgml | modified | +8 −1 |
| doc/src/sgml/config.sgml | modified | +23 −2 |
| doc/src/sgml/maintenance.sgml | modified | +34 −16 |
| src/backend/commands/cluster.c | modified | +3 −3 |
| src/backend/commands/vacuum.c | modified | +38 −5 |
| src/backend/commands/vacuumlazy.c | modified | +9 −4 |
| src/backend/nodes/copyfuncs.c | modified | +2 −2 |
| src/backend/nodes/equalfuncs.c | modified | +2 −2 |
| src/backend/parser/gram.y | modified | +6 −4 |
| src/backend/postmaster/autovacuum.c | modified | +19 −4 |
| src/backend/utils/misc/guc.c | modified | +11 −2 |
| src/backend/utils/misc/postgresql.conf.sample | modified | +2 −1 |
| src/include/catalog/catversion.h | modified | +2 −2 |
| src/include/catalog/pg_autovacuum.h | modified | +3 −1 |
| src/include/commands/vacuum.h | modified | +6 −3 |
| src/include/nodes/parsenodes.h | modified | +2 −2 |