{"Entry":{"collection":"relopts","key":"table-autovacuum-multixact-freeze-min-age","name":"autovacuum_multixact_freeze_min_age","aliases":["table.autovacuum_multixact_freeze_min_age"],"metadata":{"aliases":["table.autovacuum_multixact_freeze_min_age"],"category":"Tables and materialized views","content_hash":"31b0e07a10b0786506175ed88c7bd420f94f93c5f5868f55fd2333e14efb507d","derived_content_hash":"12d198612338d9efe726b23f65beb7af7c408b618966e2437b3369d0b80ce389","imported_at":"2026-09-30T17:44:22.202001+08:00","name":"autovacuum_multixact_freeze_min_age","name_zh":"autovacuum_multixact_freeze_min_age","repair_provenance":{"original_source_revision":"","receipt_sha256":"f0b37ecf14a3f3b22cc9fab356e29dc8dd8ed4d540cf84b3d563d475a14e57a2","repair":"wiki-repair-20261023"},"slug":"table-autovacuum-multixact-freeze-min-age","source_rev":"wiki-repair-20261023:14aeb1d07cb436bc06c92e37f7ba65f9cf553c11179c2bda71f99b9f48c621c2","summary":"Per-table value for vacuum_multixact_freeze_min_age parameter. Note that autovacuum will ignore per-table autovacuum_multixact_freeze_min_age parameters that are larger than half the system-wide autovacuum_multixact_freeze_max_age setting."}},"Definition":{"Collection":"relopts","Key":"table-autovacuum-multixact-freeze-min-age","SourceDatabase":"center","Version":"18","SourceTable":"relopt","SourceKey":"table-autovacuum-multixact-freeze-min-age","SourceRevision":"eb6c2292fdf28e1b4635ab478eec3919411cdf4a6c07553387870e26201f3744","Facts":{"description":["Per-table value for vacuum_multixact_freeze_min_age parameter. Note that autovacuum will ignore per-table autovacuum_multixact_freeze_min_age parameters that are larger than half the system-wide autovacuum_multixact_freeze_max_age setting."],"description_zh":"vacuum_multixact_freeze_min_age 参数的每表取值。注意，自动清理会忽略大于系统范围 autovacuum_multixact_freeze_max_age 设置一半的每表 autovacuum_multixact_freeze_min_age 参数。","description_zh_html":"\u003cp\u003e\n\u003ca class=\"xref\" href=\"/zh/docs/18/runtime-config-vacuum.html#GUC-VACUUM-MULTIXACT-FREEZE-MIN-AGE\"\u003evacuum_multixact_freeze_min_age\u003c/a\u003e 参数的每表取值。注意，自动清理会忽略大于系统范围 \u003ca class=\"xref\" href=\"/zh/docs/18/runtime-config-vacuum.html#GUC-AUTOVACUUM-MULTIXACT-FREEZE-MAX-AGE\"\u003eautovacuum_multixact_freeze_max_age\u003c/a\u003e 设置一半的每表\n      \u003ccode class=\"literal\"\u003eautovacuum_multixact_freeze_min_age\u003c/code\u003e 参数。\n     \u003c/p\u003e\u003ch3\u003e相关全局参数\u003c/h3\u003e\u003cp\u003e\n        指定 \u003ccode class=\"command\"\u003eVACUUM\u003c/code\u003e 在决定是否冻结带有较旧多事务 ID 的页面时应采用的截止年龄（以多事务计）。默认值为 500 万个多事务。尽管用户可以将该值设置在 0 到 10 亿之间，\u003ccode class=\"command\"\u003eVACUUM\u003c/code\u003e 仍会悄悄将其有效值限制为不超过 \u003ca class=\"xref\" href=\"/zh/docs/18/runtime-config-vacuum.html#GUC-AUTOVACUUM-MULTIXACT-FREEZE-MAX-AGE\"\u003eautovacuum_multixact_freeze_max_age\u003c/a\u003e 的一半，以避免强制自动清理之间的间隔过短。详见\u003ca class=\"xref\" href=\"/zh/docs/18/routine-vacuuming.html#VACUUM-FOR-MULTIXACT-WRAPAROUND\" title=\"24.1.5.1. 多事务与回卷\"\u003e第 24.1.5.1 节\u003c/a\u003e。\n       \u003c/p\u003e","facts":[{"label":"Applies to","value":"Tables and materialized views"},{"label":"Value type","value":"integer"}],"related":[{"label":"Global parameter vacuum_multixact_freeze_min_age","url":"/wiki/guc/vacuum_multixact_freeze_min_age/?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 relation-level setting applies to the table or materialized view. Any corresponding global parameter has a separate entry."],"title":"Scope"},{"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 cutoff age (in multixacts) that VACUUM should use to decide whether to trigger freezing of pages with an older multixact ID. The default is 5 million multixacts. Although users can set this value anywhere from zero to one billion, VACUUM will silently limit the effective value to half the value of autovacuum_multixact_freeze_max_age , so that there is not an unreasonably short time between forced autovacuums. For more information see Section 24.1.5.1 ."],"title":"Related global parameter: vacuum_multixact_freeze_min_age"}],"signature":"WITH (autovacuum_multixact_freeze_min_age = value)","sources":[{"label":"PostgreSQL 18 English manual","path":"sql-createtable.html","sha256":"b4d703391fe1102d0e02bd6769bef928513eb7a5542f38f7448fc77fe69e0d5b","url":"/docs/18/sql-createtable.html#RELOPTION-AUTOVACUUM-MULTIXACT-FREEZE-MIN-AGE"},{"label":"Related global parameter: vacuum_multixact_freeze_min_age","path":"runtime-config-vacuum.html","sha256":"7047f1fa9138b97f1812532f8a905fa7479451dfd64655e029a7d387b20b22e4","url":"/docs/18/runtime-config-vacuum.html#GUC-VACUUM-MULTIXACT-FREEZE-MIN-AGE"},{"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-MULTIXACT-FREEZE-MIN-AGE"},{"label":"Related global parameter: vacuum_multixact_freeze_min_age","path":"runtime-config-vacuum.html","sha256":"7047f1fa9138b97f1812532f8a905fa7479451dfd64655e029a7d387b20b22e4","url":"/docs/18/runtime-config-vacuum.html#GUC-VACUUM-MULTIXACT-FREEZE-MIN-AGE"},{"label":"PostgreSQL 18 English manual","path":"sql-creatematerializedview.html","sha256":"bd8a6710c9f133afee191eb0ec345ef8c54bb54db2242621d8cb683c783a8b18","url":"/docs/18/sql-creatematerializedview.html"}]},"MeasuredEvidence":{}},"Text":{"Collection":"relopts","Key":"table-autovacuum-multixact-freeze-min-age","SourceDatabase":"center","Version":"18","Locale":"en","Title":"autovacuum_multixact_freeze_min_age","Summary":"Per-table value for vacuum_multixact_freeze_min_age parameter. Note that autovacuum will ignore per-table autovacuum_multixact_freeze_min_age parameters that are larger than half the system-wide autovacuum_multixact_freeze_max_age setting.","BodyHTML":"\u003cp\u003ePer-table value for vacuum_multixact_freeze_min_age parameter. Note that autovacuum will ignore per-table autovacuum_multixact_freeze_min_age parameters that are larger than half the system-wide autovacuum_multixact_freeze_max_age setting.\u003c/p\u003e","SourceRevision":"eb6c2292fdf28e1b4635ab478eec3919411cdf4a6c07553387870e26201f3744","ContentHash":"f75918b40aece7f562966ed1dab8d9c8764d53cfbd0905fe2a7b296afd615fc7","Payload":{"description":["Per-table value for vacuum_multixact_freeze_min_age parameter. Note that autovacuum will ignore per-table autovacuum_multixact_freeze_min_age parameters that are larger than half the system-wide autovacuum_multixact_freeze_max_age setting."],"related":[{"label":"Global parameter vacuum_multixact_freeze_min_age","url":"/wiki/guc/vacuum_multixact_freeze_min_age/?v=18"},{"label":"CREATE TABLE","url":"/wiki/sql/create-table/?v=18"}],"sections":[{"paragraphs":["This relation-level setting applies to the table or materialized view. Any corresponding global parameter has a separate entry."],"title":"Scope"},{"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 cutoff age (in multixacts) that VACUUM should use to decide whether to trigger freezing of pages with an older multixact ID. The default is 5 million multixacts. Although users can set this value anywhere from zero to one billion, VACUUM will silently limit the effective value to half the value of autovacuum_multixact_freeze_max_age , so that there is not an unreasonably short time between forced autovacuums. For more information see Section 24.1.5.1 ."],"title":"Related global parameter: vacuum_multixact_freeze_min_age"}]}},"RequestedLocale":"en","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}