{"Entry":{"collection":"relopts","key":"toast-autovacuum-vacuum-max-threshold","name":"toast.autovacuum_vacuum_max_threshold","aliases":["autovacuum_vacuum_max_threshold"],"metadata":{"aliases":["autovacuum_vacuum_max_threshold"],"category":"TOAST tables","content_hash":"0b890f167a199b275e125831112ff67a6bd7c62e41d19dc715a8728e6701dabf","derived_content_hash":"d8d785a8720d1dbdeea2c5c51599473c7f6d61ece40bae9af9c6e38757342d9b","imported_at":"2026-09-30T17:44:22.372134+08:00","name":"toast.autovacuum_vacuum_max_threshold","name_zh":"TOAST autovacuum_vacuum_max_threshold","repair_provenance":{"original_source_revision":"","receipt_sha256":"13fc057f94e8f5ce1d4dd005efbb936c81426661363af8178c07e9a0a3d60736","repair":"wiki-repair-20261023"},"slug":"toast-autovacuum-vacuum-max-threshold","source_rev":"wiki-repair-20261023:a3d09efa5949922df6d01f943e262df118d5d3963db59b50fdfb44531e85f503","summary":"Per-table value for autovacuum_vacuum_max_threshold parameter."}},"Definition":{"Collection":"relopts","Key":"toast-autovacuum-vacuum-max-threshold","SourceDatabase":"center","Version":"18","SourceTable":"relopt","SourceKey":"toast-autovacuum-vacuum-max-threshold","SourceRevision":"eb6c2292fdf28e1b4635ab478eec3919411cdf4a6c07553387870e26201f3744","Facts":{"description":["Per-table value for autovacuum_vacuum_max_threshold parameter."],"description_zh":"autovacuum_vacuum_max_threshold 参数的每表取值。","description_zh_html":"\u003cp\u003e\n\u003ca class=\"xref\" href=\"/zh/docs/18/runtime-config-vacuum.html#GUC-AUTOVACUUM-VACUUM-MAX-THRESHOLD\"\u003eautovacuum_vacuum_max_threshold\u003c/a\u003e 参数的每表取值。\n    \u003c/p\u003e\u003ch3\u003e相关全局参数\u003c/h3\u003e\u003cp\u003e\n\t        指定在任意一个表上触发 \u003ccode class=\"command\"\u003eVACUUM\u003c/code\u003e 所需更新或删除元组数的最大值，也就是对\n\t        \u003ccode class=\"varname\"\u003eautovacuum_vacuum_threshold\u003c/code\u003e 和\n\t        \u003ccode class=\"varname\"\u003eautovacuum_vacuum_scale_factor\u003c/code\u003e 计算结果所施加的上限。默认值为 100,000,000 个元组。如果指定为 \u003ccode class=\"literal\"\u003e-1\u003c/code\u003e，自动清理将不会对触发\n\t        \u003ccode class=\"command\"\u003eVACUUM\u003c/code\u003e 所需的更新或删除元组数强制施加最大值。该参数只能在 \u003ccode class=\"filename\"\u003epostgresql.conf\u003c/code\u003e 文件中或服务器命令行上设置；但可以通过更改表存储参数覆盖单个表的该设置。\n\t       \u003c/p\u003e","facts":[{"label":"Applies to","value":"TOAST tables"},{"label":"Value type","value":"integer"}],"related":[{"label":"Table option autovacuum_vacuum_max_threshold","url":"/wiki/relopts/table-autovacuum-vacuum-max-threshold/?v=18"},{"label":"Global parameter autovacuum_vacuum_max_threshold","url":"/wiki/guc/autovacuum_vacuum_max_threshold/?v=18"},{"label":"CREATE TABLE","url":"/wiki/sql/create-table/?v=18"}],"release":{"channel":"stable","label":"18.6","major":"18","ref":"Local English manual 18.6","revision":"eb6c2292fdf28e1b4635ab478eec3919411cdf4a6c07553387870e26201f3744"},"sections":[{"paragraphs":["This option applies to the associated TOAST table. Set it with the toast. prefix in WITH or ALTER TABLE SET. An unset TOAST option inherits the corresponding explicitly set parent-table option.","The manual describes table and TOAST forms together. Autoanalyze does not apply to TOAST tables; only explicitly documented toast. forms are listed here."],"title":"TOAST inheritance"},{"paragraphs":["The WITH clause can specify storage parameters for tables, and for indexes associated with a UNIQUE , PRIMARY KEY , or EXCLUDE constraint. Storage parameters for indexes are documented in CREATE INDEX . The storage parameters currently available for tables are listed below. For many of these parameters, as shown, there is an additional parameter with the same name prefixed with toast. , which controls the behavior of the table's secondary TOAST table, if any (see Section 66.2 for more information about TOAST). If a table parameter value is set and the equivalent toast. parameter is not, the TOAST table will use the table's parameter value. Specifying these parameters for partitioned tables is not supported, but you may specify them for individual leaf partitions."],"title":"Common table storage rules"},{"paragraphs":["This clause specifies optional storage parameters for the new materialized view; see Storage Parameters in the CREATE TABLE documentation for more information. All parameters supported for CREATE TABLE are also supported for CREATE MATERIALIZED VIEW . See CREATE TABLE for more information."],"title":"Materialized views"},{"paragraphs":["The following same-version GUC definition explains its purpose and units. Global defaults and activation rules describe the GUC; the relation-option override rules remain those above.","Specifies the maximum number of updated or deleted tuples needed to trigger a VACUUM in any one table, i.e., a limit on the value calculated with autovacuum_vacuum_threshold and autovacuum_vacuum_scale_factor . The default is 100,000,000 tuples. If -1 is specified, autovacuum will not enforce a maximum number of updated or deleted tuples that will trigger a VACUUM operation. 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 storage parameters."],"title":"Related global parameter: autovacuum_vacuum_max_threshold"}],"signature":"WITH (toast.autovacuum_vacuum_max_threshold = value)","sources":[{"label":"PostgreSQL 18 English manual","path":"sql-createtable.html","sha256":"b4d703391fe1102d0e02bd6769bef928513eb7a5542f38f7448fc77fe69e0d5b","url":"/docs/18/sql-createtable.html#RELOPTION-AUTOVACUUM-VACUUM-MAX-THRESHOLD"},{"label":"Related global parameter: autovacuum_vacuum_max_threshold","path":"runtime-config-vacuum.html","sha256":"7047f1fa9138b97f1812532f8a905fa7479451dfd64655e029a7d387b20b22e4","url":"/docs/18/runtime-config-vacuum.html#GUC-AUTOVACUUM-VACUUM-MAX-THRESHOLD"},{"label":"PostgreSQL 18 English manual","path":"sql-creatematerializedview.html","sha256":"bd8a6710c9f133afee191eb0ec345ef8c54bb54db2242621d8cb683c783a8b18","url":"/docs/18/sql-creatematerializedview.html"}],"translation_provenance":{"inputs":[{"kind":"current-pgdoc-translation","path":"/Users/vonng/pgsty/pgdoc/zh/18/html/sql-createtable.html","sha256":"c044586c69b191e0f39966b25811a0c70f12fe2bf5e7f640501e53d76ca8f775"},{"kind":"current-pgdoc-translation","path":"/Users/vonng/pgsty/pgdoc/zh/18/html/runtime-config-vacuum.html","sha256":"ea621aa6ed500fc56d21868a21fd313872cec24b86caf4c8f9bdfdc804b8235f"}],"kind":"same-version-pgdoc","locale":"zh-Hans","source_revision":"b1b500221dbe5437cfca004d6b04d3f6e422765d","version":"18"},"zh_from":"same-version-pgdoc"},"ManualEvidence":{"release":{"channel":"stable","label":"18.6","major":"18","ref":"Local English manual 18.6","revision":"eb6c2292fdf28e1b4635ab478eec3919411cdf4a6c07553387870e26201f3744"},"sources":[{"label":"PostgreSQL 18 English manual","path":"sql-createtable.html","sha256":"b4d703391fe1102d0e02bd6769bef928513eb7a5542f38f7448fc77fe69e0d5b","url":"/docs/18/sql-createtable.html#RELOPTION-AUTOVACUUM-VACUUM-MAX-THRESHOLD"},{"label":"Related global parameter: autovacuum_vacuum_max_threshold","path":"runtime-config-vacuum.html","sha256":"7047f1fa9138b97f1812532f8a905fa7479451dfd64655e029a7d387b20b22e4","url":"/docs/18/runtime-config-vacuum.html#GUC-AUTOVACUUM-VACUUM-MAX-THRESHOLD"},{"label":"PostgreSQL 18 English manual","path":"sql-creatematerializedview.html","sha256":"bd8a6710c9f133afee191eb0ec345ef8c54bb54db2242621d8cb683c783a8b18","url":"/docs/18/sql-creatematerializedview.html"}]},"MeasuredEvidence":{}},"Text":{"Collection":"relopts","Key":"toast-autovacuum-vacuum-max-threshold","SourceDatabase":"center","Version":"18","Locale":"en","Title":"toast.autovacuum_vacuum_max_threshold","Summary":"Per-table value for autovacuum_vacuum_max_threshold parameter.","BodyHTML":"\u003cp\u003ePer-table value for autovacuum_vacuum_max_threshold parameter.\u003c/p\u003e","SourceRevision":"eb6c2292fdf28e1b4635ab478eec3919411cdf4a6c07553387870e26201f3744","ContentHash":"c827aea7fe11542cabbd01a11b9e0407fdf2317f8038a8d385c8cc98c8fafbe8","Payload":{"description":["Per-table value for autovacuum_vacuum_max_threshold parameter."],"related":[{"label":"Table option autovacuum_vacuum_max_threshold","url":"/wiki/relopts/table-autovacuum-vacuum-max-threshold/?v=18"},{"label":"Global parameter autovacuum_vacuum_max_threshold","url":"/wiki/guc/autovacuum_vacuum_max_threshold/?v=18"},{"label":"CREATE TABLE","url":"/wiki/sql/create-table/?v=18"}],"sections":[{"paragraphs":["This option applies to the associated TOAST table. Set it with the toast. prefix in WITH or ALTER TABLE SET. An unset TOAST option inherits the corresponding explicitly set parent-table option.","The manual describes table and TOAST forms together. Autoanalyze does not apply to TOAST tables; only explicitly documented toast. forms are listed here."],"title":"TOAST inheritance"},{"paragraphs":["The WITH clause can specify storage parameters for tables, and for indexes associated with a UNIQUE , PRIMARY KEY , or EXCLUDE constraint. Storage parameters for indexes are documented in CREATE INDEX . The storage parameters currently available for tables are listed below. For many of these parameters, as shown, there is an additional parameter with the same name prefixed with toast. , which controls the behavior of the table's secondary TOAST table, if any (see Section 66.2 for more information about TOAST). If a table parameter value is set and the equivalent toast. parameter is not, the TOAST table will use the table's parameter value. Specifying these parameters for partitioned tables is not supported, but you may specify them for individual leaf partitions."],"title":"Common table storage rules"},{"paragraphs":["This clause specifies optional storage parameters for the new materialized view; see Storage Parameters in the CREATE TABLE documentation for more information. All parameters supported for CREATE TABLE are also supported for CREATE MATERIALIZED VIEW . See CREATE TABLE for more information."],"title":"Materialized views"},{"paragraphs":["The following same-version GUC definition explains its purpose and units. Global defaults and activation rules describe the GUC; the relation-option override rules remain those above.","Specifies the maximum number of updated or deleted tuples needed to trigger a VACUUM in any one table, i.e., a limit on the value calculated with autovacuum_vacuum_threshold and autovacuum_vacuum_scale_factor . The default is 100,000,000 tuples. If -1 is specified, autovacuum will not enforce a maximum number of updated or deleted tuples that will trigger a VACUUM operation. 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 storage parameters."],"title":"Related global parameter: autovacuum_vacuum_max_threshold"}]}},"RequestedLocale":"en","Fallback":false,"Versions":["18","19","20"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}