pg_autovacuum
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.
英文手册覆盖始于 PostgreSQL 7.4. 来源历史与运行验证各自保留独立版本边界。
当前阅读 PG 8.3·选择有来源记录的版本
此版本暂无所选语言的定义，以下显示原始英文内容。
- kind
- catalog
- lang
- en
- measured attributes
- false
- metadata release
- 未知
- runtime verified
- false
- source
- english-manual
版本定义 PG 8.3
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.
目录列
| 列 | 类型 | 可空性 | 描述 |
|---|---|---|---|
| vacrelid | oid | 未知 | The table this entry is for |
| enabled | bool | 未知 | If false, this table will not be autovacuumed, except to prevent transaction ID wraparound |
| vac_base_thresh | integer | 未知 | Minimum number of modified tuples before vacuum |
| vac_scale_factor | float4 | 未知 | Multiplier for reltuples to add to vac_base_thresh |
| anl_base_thresh | integer | 未知 | Minimum number of modified tuples before analyze |
| anl_scale_factor | float4 | 未知 | Multiplier for reltuples to add to anl_base_thresh |
| vac_cost_delay | integer | 未知 | Custom vacuum_cost_delay parameter |
| vac_cost_limit | integer | 未知 | Custom vacuum_cost_limit parameter |
| freeze_min_age | integer | 未知 | Custom vacuum_freeze_min_age parameter |
| freeze_max_age | integer | 未知 | Custom autovacuum_freeze_max_age parameter |
比较版本
来源引用
定义来源
center · PostgreSQL 8.3 · english-manuals:e0f9db2a5241809b50043ae7f85b62800b1d1e78cf4e4dee39571a346a9bd2fb
正文语言: en · english-manuals:e0f9db2a5241809b50043ae7f85b62800b1d1e78cf4e4dee39571a346a9bd2fb