pg_autovacuum
A former system table storing per-table autovacuum settings
This entry relates to a PostgreSQL feature, application/utility, website or other subject which is no longer available/maintained.
pg_autovacuum
was a system catalogue table storing per-table autovacuum settings.
It was introduced in PostgreSQL 8.1, replacing the contrib module of the same name, and removed in PostgreSQL 8.4, when per-table autovacuum settings were migrated to relopts.
Definition by PostgreSQL version
pg_autovacuum (PostgreSQL 8.3)
Table "pg_catalog.pg_autovacuum" Column | Type | Modifiers ------------------+---------+----------- vacrelid | oid | not null enabled | boolean | not null vac_base_thresh | integer | not null vac_scale_factor | real | not null anl_base_thresh | integer | not null anl_scale_factor | real | not null vac_cost_delay | integer | not null vac_cost_limit | integer | not null freeze_min_age | integer | not null freeze_max_age | integer | not null Indexes: "pg_autovacuum_vacrelid_index" UNIQUE, btree (vacrelid)
Documentation: pg_autovacuum
pg_autovacuum (PostgreSQL 8.2)
Table "pg_catalog.pg_autovacuum" Column | Type | Modifiers ------------------+---------+----------- vacrelid | oid | not null enabled | boolean | not null vac_base_thresh | integer | not null vac_scale_factor | real | not null anl_base_thresh | integer | not null anl_scale_factor | real | not null vac_cost_delay | integer | not null vac_cost_limit | integer | not null freeze_min_age | integer | not null freeze_max_age | integer | not null Indexes: "pg_autovacuum_vacrelid_index" UNIQUE, btree (vacrelid)
Documentation: pg_autovacuum
Change history
- PostgreSQL 8.4
- removed (commit 834a6da4)
- PostgreSQL 8.1
- added (commit 29094193)
References
- PostgreSQL 8.3 documentation: pg_autovacuum
Categories
See also
autovacuum