Contents

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

Categories

Obsolete, System catalogue

See also

autovacuum