↑↓ 选择↵ 打开⌫ 切换范围完整搜索

PG.CENTER 连接 PostgreSQL 文档、百科与生态知识。由 Pigsty 维护。

Wiki / 配置参数

autovacuum_vacuum_insert_threshold

Specifies the number of inserted tuples needed to trigger a VACUUM in any one table. The default is 1000 tuples. If -1 is specified, autovacuum will not trigger a VACUUM operation on any tables based on the number of inserts. This parameter can only be set in the postgresql.conf file or on the server command line; but the setting can be overridden for individual tables by changing table storage parameters.

英文手册覆盖始于 PostgreSQL 7.4. 来源历史与运行验证各自保留独立版本边界。

当前阅读 PG 18·选择有来源记录的版本

此版本暂无所选语言的定义,以下显示原始英文内容。

boot val
1000
category
Vacuuming / Automatic Vacuuming
context
sighup
documented
true
enumvals
未知
extra desc
-1 disables insert vacuums.
lang
en
max val
2147483647
metadata version
18
min val
-1
name
autovacuum_vacuum_insert_threshold
short desc
Minimum number of tuple inserts prior to vacuum.
source
pg-settings-source-snapshot
unit
未知
vartype
integer

版本定义 PG 18

Specifies the number of inserted tuples needed to trigger a VACUUM in any one table. The default is 1000 tuples. If -1 is specified, autovacuum will not trigger a VACUUM operation on any tables based on the number of inserts. This parameter can only be set in the postgresql.conf file or on the server command line; but the setting can be overridden for individual tables by changing table storage parameters.

比较版本

来源引用

完整定义与证据 JSON

定义来源

center · PostgreSQL 18 · english-manuals:9c3f9d9fbf2e15fa70283f9b915da475f42736c3c716d77e0508cb4f556cddf2

正文语言: en · english-manuals:9c3f9d9fbf2e15fa70283f9b915da475f42736c3c716d77e0508cb4f556cddf2