类型: integer
默认: 50000000
最低限度: 0
最大: 1000000000
上下文: user
重新开始: false

指定VACUUM在扫描一个表时用于判断是否用FrozenXID 替换事务ID的中断寿命(在同一个事务中)。 缺省值为50百万。虽然用户可以指定一个 0-1000000000之间的值, 但是VACUUM将会悄无声息的将有效值限制在autovacuum_freeze_max_age的一半之内。 更多信息参见vacuum-for-wraparound

建议 [EN]

Most users will want to decrease this so that rows which have been cold for a long time get frozen earlier, and avoid an autovacuum_freeze. The suggestion of 500000 is for a moderately busy database; do not set to less than a few hours worth of XIDs. Maximum setting is 1/2 of autovaccuum_max_freeze_age.

条评论