{"Entry":{"collection":"catalog","key":"pg_autovacuum","name":"pg_autovacuum","aliases":[],"metadata":{"changed_in":["8.2"],"changes":[{"added":[],"attributes":[],"description_changed":false,"descriptions":[],"from":"8.0","order":false,"removed":[],"status":"added","to":"8.1","types":[]},{"added":["freeze_min_age","freeze_max_age"],"attributes":[],"description_changed":true,"descriptions":[{"from":"If false, this table is never autovacuumed","name":"enabled","to":"If false, this table will not be autovacuumed, except to prevent transaction ID wraparound"}],"from":"8.1","listing":[],"order":false,"removed":[],"status":"changed","to":"8.2","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[],"from":"8.2","listing":[],"order":false,"removed":[],"status":"reworded","to":"8.3","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[],"from":"8.3","order":false,"removed":[],"status":"removed","to":"8.4","types":[]}],"column_count":10,"content_hash":"3746b6f855f492a14f4bef2e498ac621426cab026f401da582c4ff647c49a598","first_version":"8.1","imported_at":"2026-09-30T00:40:55.382993+08:00","kind":"catalog","last_version":"8.3","name":"pg_autovacuum","position":9,"present_in":["8.1","8.2","8.3"],"relation_oid":null,"relkind":"r","shared":false,"source_rev":"english-manuals:e0f9db2a5241809b50043ae7f85b62800b1d1e78cf4e4dee39571a346a9bd2fb","summary":"The catalog pg_autovacuum stores optional per-relation configuration parameters for the autovacuum daemon.","summary_zh":""}},"Definition":{"Collection":"catalog","Key":"pg_autovacuum","SourceDatabase":"center","Version":"8.3","SourceTable":"catalog","SourceKey":"pg_autovacuum","SourceRevision":"english-manuals:e0f9db2a5241809b50043ae7f85b62800b1d1e78cf4e4dee39571a346a9bd2fb","Facts":{"columns":[{"description":"The table this entry is for","description_zh":"","documented":true,"documented_name":"vacrelid","hidden":false,"name":"vacrelid","references":"pg_class.oid","type":"oid"},{"description":"If false, this table will not be autovacuumed, except to prevent transaction ID wraparound","description_zh":"","documented":true,"documented_name":"enabled","hidden":false,"name":"enabled","references":"","type":"bool"},{"description":"Minimum number of modified tuples before vacuum","description_zh":"","documented":true,"documented_name":"vac_base_thresh","hidden":false,"name":"vac_base_thresh","references":"","type":"integer"},{"description":"Multiplier for reltuples to add to vac_base_thresh","description_zh":"","documented":true,"documented_name":"vac_scale_factor","hidden":false,"name":"vac_scale_factor","references":"","type":"float4"},{"description":"Minimum number of modified tuples before analyze","description_zh":"","documented":true,"documented_name":"anl_base_thresh","hidden":false,"name":"anl_base_thresh","references":"","type":"integer"},{"description":"Multiplier for reltuples to add to anl_base_thresh","description_zh":"","documented":true,"documented_name":"anl_scale_factor","hidden":false,"name":"anl_scale_factor","references":"","type":"float4"},{"description":"Custom vacuum_cost_delay parameter","description_zh":"","documented":true,"documented_name":"vac_cost_delay","hidden":false,"name":"vac_cost_delay","references":"","type":"integer"},{"description":"Custom vacuum_cost_limit parameter","description_zh":"","documented":true,"documented_name":"vac_cost_limit","hidden":false,"name":"vac_cost_limit","references":"","type":"integer"},{"description":"Custom vacuum_freeze_min_age parameter","description_zh":"","documented":true,"documented_name":"freeze_min_age","hidden":false,"name":"freeze_min_age","references":"","type":"integer"},{"description":"Custom autovacuum_freeze_max_age parameter","description_zh":"","documented":true,"documented_name":"freeze_max_age","hidden":false,"name":"freeze_max_age","references":"","type":"integer"}],"description":"The catalog pg_autovacuum stores optional per-relation configuration parameters for the autovacuum daemon. If there is an entry here for a particular relation, the given parameters will be used for autovacuuming that table. If no entry is present, the system-wide defaults will be used. For more information about the autovacuum daemon, see Section 23.1.4.","description_zh":"","doc":{"anchor":"AEN68987","file":"catalog-pg-autovacuum.html","lang":"en","sha256":"73f7397fd24f08990ab2b47c63d3a68399c170b957a11691945401a45ed15984","slug":"8.3"},"kind":"catalog","lang":"en","measured_attributes":false,"metadata_release":"","runtime_verified":false,"source":"english-manual"},"ManualEvidence":{"doc":{"anchor":"AEN68987","file":"catalog-pg-autovacuum.html","lang":"en","sha256":"73f7397fd24f08990ab2b47c63d3a68399c170b957a11691945401a45ed15984","slug":"8.3"}},"MeasuredEvidence":{"measured_attributes":false,"metadata_release":"","runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_autovacuum","SourceDatabase":"center","Version":"8.3","Locale":"en","Title":"pg_autovacuum","Summary":"The catalog pg_autovacuum stores optional per-relation configuration parameters for the autovacuum daemon. If there is an entry here for a particular relation, the given parameters will be used for autovacuuming that table. If no entry is present, the system-wide defaults will be used. For more information about the autovacuum daemon, see Section 23.1.4.","BodyHTML":"\u003cp\u003eThe catalog pg_autovacuum stores optional per-relation configuration parameters for the autovacuum daemon. If there is an entry here for a particular relation, the given parameters will be used for autovacuuming that table. If no entry is present, the system-wide defaults will be used. For more information about the autovacuum daemon, see Section 23.1.4.\u003c/p\u003e","SourceRevision":"english-manuals:e0f9db2a5241809b50043ae7f85b62800b1d1e78cf4e4dee39571a346a9bd2fb","ContentHash":"846704f91b5bf657cc0c06ed24934cd19bf9af83dffeaf6567285a92cef347d0","Payload":{"columns":[{"description":"The table this entry is for","description_zh":"","documented":true,"documented_name":"vacrelid","hidden":false,"name":"vacrelid","references":"pg_class.oid","type":"oid"},{"description":"If false, this table will not be autovacuumed, except to prevent transaction ID wraparound","description_zh":"","documented":true,"documented_name":"enabled","hidden":false,"name":"enabled","references":"","type":"bool"},{"description":"Minimum number of modified tuples before vacuum","description_zh":"","documented":true,"documented_name":"vac_base_thresh","hidden":false,"name":"vac_base_thresh","references":"","type":"integer"},{"description":"Multiplier for reltuples to add to vac_base_thresh","description_zh":"","documented":true,"documented_name":"vac_scale_factor","hidden":false,"name":"vac_scale_factor","references":"","type":"float4"},{"description":"Minimum number of modified tuples before analyze","description_zh":"","documented":true,"documented_name":"anl_base_thresh","hidden":false,"name":"anl_base_thresh","references":"","type":"integer"},{"description":"Multiplier for reltuples to add to anl_base_thresh","description_zh":"","documented":true,"documented_name":"anl_scale_factor","hidden":false,"name":"anl_scale_factor","references":"","type":"float4"},{"description":"Custom vacuum_cost_delay parameter","description_zh":"","documented":true,"documented_name":"vac_cost_delay","hidden":false,"name":"vac_cost_delay","references":"","type":"integer"},{"description":"Custom vacuum_cost_limit parameter","description_zh":"","documented":true,"documented_name":"vac_cost_limit","hidden":false,"name":"vac_cost_limit","references":"","type":"integer"},{"description":"Custom vacuum_freeze_min_age parameter","description_zh":"","documented":true,"documented_name":"freeze_min_age","hidden":false,"name":"freeze_min_age","references":"","type":"integer"},{"description":"Custom autovacuum_freeze_max_age parameter","description_zh":"","documented":true,"documented_name":"freeze_max_age","hidden":false,"name":"freeze_max_age","references":"","type":"integer"}],"description":"The catalog pg_autovacuum stores optional per-relation configuration parameters for the autovacuum daemon. If there is an entry here for a particular relation, the given parameters will be used for autovacuuming that table. If no entry is present, the system-wide defaults will be used. For more information about the autovacuum daemon, see Section 23.1.4."}},"RequestedLocale":"zh-Hans","Fallback":true,"Versions":["8.1","8.2","8.3"],"Locales":["en"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}