Autovacuum loose end mop-up. Provide autovacuum-specific vacuum cost
Tom Lane <tgl@sss.pgh.pa.us>
Autovacuum loose end mop-up. Provide autovacuum-specific vacuum cost delay and limit, both as global GUCs and as table-specific entries in pg_autovacuum. stats_reset_on_server_start is now OFF by default, but a reset is forced if we did WAL replay. XID-wrap vacuums do not ANALYZE, but do FREEZE if it's a template database. Alvaro Herrera
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/catalogs.sgml | modified | +20 −2 |
| doc/src/sgml/runtime.sgml | modified | +36 −2 |
| src/backend/access/transam/xlog.c | modified | +8 −2 |
| src/backend/libpq/hba.c | modified | +8 −2 |
| src/backend/postmaster/autovacuum.c | modified | +258 −136 |
| src/backend/postmaster/pgstat.c | modified | +28 −8 |
| src/backend/postmaster/postmaster.c | modified | +6 −1 |
| src/backend/tcop/postgres.c | modified | +2 −3 |
| src/backend/utils/init/flatfiles.c | modified | +13 −8 |
| src/backend/utils/init/postinit.c | modified | +27 −26 |
| src/backend/utils/misc/guc.c | modified | +20 −2 |
| src/backend/utils/misc/postgresql.conf.sample | modified | +5 −1 |
| src/include/catalog/catversion.h | modified | +2 −2 |
| src/include/catalog/pg_autovacuum.h | modified | +6 −2 |
| src/include/libpq/hba.h | modified | +3 −2 |
| src/include/pgstat.h | modified | +2 −1 |
| src/include/postmaster/autovacuum.h | modified | +3 −1 |
| src/include/tcop/tcopprot.h | modified | +2 −1 |