{"kind": "relopts", "major": "18", "item": {"slug": "toast-autovacuum-multixact-freeze-table-age", "name": "toast.autovacuum_multixact_freeze_table_age", "name_zh": "TOAST autovacuum_multixact_freeze_table_age", "category": "TOAST tables", "summary": "Per-table value for vacuum_multixact_freeze_table_age parameter.", "aliases": ["autovacuum_multixact_freeze_table_age"], "versions": {"10": {"facts": [{"label": "Applies to", "value": "TOAST tables"}, {"label": "Value type", "value": "integer"}], "related": [{"url": "/docs/relopts/table-autovacuum-multixact-freeze-table-age/?v=10", "label": "Table option autovacuum_multixact_freeze_table_age"}, {"url": "/docs/guc/vacuum_multixact_freeze_table_age/?v=10", "label": "Global parameter vacuum_multixact_freeze_table_age"}, {"url": "/docs/sql/create-table/?v=10", "label": "CREATE TABLE"}], "release": {"ref": "Local English manual 10.23", "label": "10.23", "major": "10", "channel": "historical", "revision": "4ff6f6193d91bf44fc701f657cc3295850bf786e42eafbfeed9f4879c3522613"}, "sources": [{"url": "/docs/10/sql-createtable.html#SQL-CREATETABLE-STORAGE-PARAMETERS", "path": "sql-createtable.html", "label": "PostgreSQL 10 English manual", "sha256": "6a9df6e68f8acd82ca864475616f6c1cf483c97f96abfc2c2abd565aeb4129a5"}, {"url": "/docs/10/runtime-config-client.html#GUC-VACUUM-MULTIXACT-FREEZE-TABLE-AGE", "path": "runtime-config-client.html", "label": "Related global parameter: vacuum_multixact_freeze_table_age", "sha256": "81c199a46b03a65a060e25cf874fc7ddd28b18261a6472a912954073556935b4"}, {"url": "/docs/10/sql-creatematerializedview.html", "path": "sql-creatematerializedview.html", "label": "PostgreSQL 10 English manual", "sha256": "46695b2591db26e272812f8d72ebfb2f37bbbf419123ff71792fe0af027ce785"}], "sections": [{"title": "TOAST inheritance", "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": "Common table storage rules", "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 67.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": "Materialized views", "paragraphs": ["This clause specifies optional storage parameters for the new materialized view; see Storage Parameters for more information. All parameters supported for CREATE TABLE are also supported for CREATE MATERIALIZED VIEW with the exception of OIDS . See CREATE TABLE for more information."]}, {"title": "Related global parameter: vacuum_multixact_freeze_table_age", "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.", "VACUUM performs an aggressive scan if the table's pg_class . relminmxid field has reached the age specified by this setting. An aggressive scan differs from a regular VACUUM in that it visits every page that might contain unfrozen XIDs or MXIDs, not just those that might contain dead tuples. The default is 150 million multixacts. Although users can set this value anywhere from zero to two billions, VACUUM will silently limit the effective value to 95% of autovacuum_multixact_freeze_max_age , so that a periodical manual VACUUM has a chance to run before an anti-wraparound is launched for the table. For more information see Section 24.1.5.1 ."]}], "signature": "WITH (toast.autovacuum_multixact_freeze_table_age = value)", "description": ["Per-table value for vacuum_multixact_freeze_table_age parameter."]}, "11": {"facts": [{"label": "Applies to", "value": "TOAST tables"}, {"label": "Value type", "value": "integer"}], "related": [{"url": "/docs/relopts/table-autovacuum-multixact-freeze-table-age/?v=11", "label": "Table option autovacuum_multixact_freeze_table_age"}, {"url": "/docs/guc/vacuum_multixact_freeze_table_age/?v=11", "label": "Global parameter vacuum_multixact_freeze_table_age"}, {"url": "/docs/sql/create-table/?v=11", "label": "CREATE TABLE"}], "release": {"ref": "Local English manual 11.22", "label": "11.22", "major": "11", "channel": "historical", "revision": "284f2186559443efefbb1ea3b00740c25dccd01e540ecbdb81dadf5127e54a0b"}, "sources": [{"url": "/docs/11/sql-createtable.html#SQL-CREATETABLE-STORAGE-PARAMETERS", "path": "sql-createtable.html", "label": "PostgreSQL 11 English manual", "sha256": "46282e6bc95b6c42283c9fe7b79c31be21cafaa5a18dda82b7793cd21f400075"}, {"url": "/docs/11/runtime-config-client.html#GUC-VACUUM-MULTIXACT-FREEZE-TABLE-AGE", "path": "runtime-config-client.html", "label": "Related global parameter: vacuum_multixact_freeze_table_age", "sha256": "488947b3f6c09ac9a815b8602e852239936b403ef214249fee7aeca1469c25ba"}, {"url": "/docs/11/sql-creatematerializedview.html", "path": "sql-creatematerializedview.html", "label": "PostgreSQL 11 English manual", "sha256": "c9718b3ccdec9aea0bff15bbe8c31ceaff935ebb0c2d372ce37101924aafe5d3"}], "sections": [{"title": "TOAST inheritance", "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": "Common table storage rules", "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 69.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": "Materialized views", "paragraphs": ["This clause specifies optional storage parameters for the new materialized view; see Storage Parameters for more information. All parameters supported for CREATE TABLE are also supported for CREATE MATERIALIZED VIEW with the exception of OIDS . See CREATE TABLE for more information."]}, {"title": "Related global parameter: vacuum_multixact_freeze_table_age", "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.", "VACUUM performs an aggressive scan if the table's pg_class . relminmxid field has reached the age specified by this setting. An aggressive scan differs from a regular VACUUM in that it visits every page that might contain unfrozen XIDs or MXIDs, not just those that might contain dead tuples. The default is 150 million multixacts. Although users can set this value anywhere from zero to two billions, VACUUM will silently limit the effective value to 95% of autovacuum_multixact_freeze_max_age , so that a periodical manual VACUUM has a chance to run before an anti-wraparound is launched for the table. For more information see Section 24.1.5.1 ."]}], "signature": "WITH (toast.autovacuum_multixact_freeze_table_age = value)", "description": ["Per-table value for vacuum_multixact_freeze_table_age parameter."]}, "12": {"facts": [{"label": "Applies to", "value": "TOAST tables"}, {"label": "Value type", "value": "integer"}], "related": [{"url": "/docs/relopts/table-autovacuum-multixact-freeze-table-age/?v=12", "label": "Table option autovacuum_multixact_freeze_table_age"}, {"url": "/docs/guc/vacuum_multixact_freeze_table_age/?v=12", "label": "Global parameter vacuum_multixact_freeze_table_age"}, {"url": "/docs/sql/create-table/?v=12", "label": "CREATE TABLE"}], "release": {"ref": "Local English manual 12.22", "label": "12.22", "major": "12", "channel": "historical", "revision": "0a1032bc0c23478646e9ee7d36edb066dca27b8540fd64d7fd47dcb6a8a6ccb4"}, "sources": [{"url": "/docs/12/sql-createtable.html#RELOPTION-AUTOVACUUM-MULTIXACT-FREEZE-TABLE-AGE", "path": "sql-createtable.html", "label": "PostgreSQL 12 English manual", "sha256": "7210cf3ff82ffa37ef81ebbbc252e4807649dcb86050eaa3ea5fcba40a768656"}, {"url": "/docs/12/runtime-config-client.html#GUC-VACUUM-MULTIXACT-FREEZE-TABLE-AGE", "path": "runtime-config-client.html", "label": "Related global parameter: vacuum_multixact_freeze_table_age", "sha256": "7f27882cdde3b36cef070cdd14ce3f080b65ed837d3f6b41f3faf454ba89cc63"}, {"url": "/docs/12/sql-creatematerializedview.html", "path": "sql-creatematerializedview.html", "label": "PostgreSQL 12 English manual", "sha256": "2656497bc190ed29c24c29787f3ae68621830eee6345d291700c1ef8843f8dfe"}], "sections": [{"title": "TOAST inheritance", "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": "Common table storage rules", "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 69.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": "Materialized views", "paragraphs": ["This clause specifies optional storage parameters for the new materialized view; see Storage Parameters for more information. All parameters supported for CREATE TABLE are also supported for CREATE MATERIALIZED VIEW . See CREATE TABLE for more information."]}, {"title": "Related global parameter: vacuum_multixact_freeze_table_age", "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.", "VACUUM performs an aggressive scan if the table's pg_class . relminmxid field has reached the age specified by this setting. An aggressive scan differs from a regular VACUUM in that it visits every page that might contain unfrozen XIDs or MXIDs, not just those that might contain dead tuples. The default is 150 million multixacts. Although users can set this value anywhere from zero to two billions, VACUUM will silently limit the effective value to 95% of autovacuum_multixact_freeze_max_age , so that a periodical manual VACUUM has a chance to run before an anti-wraparound is launched for the table. For more information see Section 24.1.5.1 ."]}], "signature": "WITH (toast.autovacuum_multixact_freeze_table_age = value)", "description": ["Per-table value for vacuum_multixact_freeze_table_age parameter."]}, "13": {"facts": [{"label": "Applies to", "value": "TOAST tables"}, {"label": "Value type", "value": "integer"}], "related": [{"url": "/docs/relopts/table-autovacuum-multixact-freeze-table-age/?v=13", "label": "Table option autovacuum_multixact_freeze_table_age"}, {"url": "/docs/guc/vacuum_multixact_freeze_table_age/?v=13", "label": "Global parameter vacuum_multixact_freeze_table_age"}, {"url": "/docs/sql/create-table/?v=13", "label": "CREATE TABLE"}], "release": {"ref": "Local English manual 13.23", "label": "13.23", "major": "13", "channel": "historical", "revision": "346825c2d5fbebb2bd997afbb2d49edfd782dce050c0b934e84a883e5446a99f"}, "sources": [{"url": "/docs/13/sql-createtable.html#RELOPTION-AUTOVACUUM-MULTIXACT-FREEZE-TABLE-AGE", "path": "sql-createtable.html", "label": "PostgreSQL 13 English manual", "sha256": "912dd15faaa243438f33082160f2848636d1940afea42c36cf6d21a2a46c8cb8"}, {"url": "/docs/13/runtime-config-client.html#GUC-VACUUM-MULTIXACT-FREEZE-TABLE-AGE", "path": "runtime-config-client.html", "label": "Related global parameter: vacuum_multixact_freeze_table_age", "sha256": "5d70022f2524a39e7c5745698de51d867f687c70394779ad154e05648e923c7d"}, {"url": "/docs/13/sql-creatematerializedview.html", "path": "sql-creatematerializedview.html", "label": "PostgreSQL 13 English manual", "sha256": "1d2de5d4ff709d2bab07b91c964d89ce8b9236d9aa99b83b79392d24d7b74fd3"}], "sections": [{"title": "TOAST inheritance", "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": "Common table storage rules", "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 69.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": "Materialized views", "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": "Related global parameter: vacuum_multixact_freeze_table_age", "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.", "VACUUM performs an aggressive scan if the table's pg_class . relminmxid field has reached the age specified by this setting. An aggressive scan differs from a regular VACUUM in that it visits every page that might contain unfrozen XIDs or MXIDs, not just those that might contain dead tuples. The default is 150 million multixacts. Although users can set this value anywhere from zero to two billion, VACUUM will silently limit the effective value to 95% of autovacuum_multixact_freeze_max_age , so that a periodic manual VACUUM has a chance to run before an anti-wraparound is launched for the table. For more information see Section 24.1.5.1 ."]}], "signature": "WITH (toast.autovacuum_multixact_freeze_table_age = value)", "description": ["Per-table value for vacuum_multixact_freeze_table_age parameter."]}, "14": {"facts": [{"label": "Applies to", "value": "TOAST tables"}, {"label": "Value type", "value": "integer"}], "related": [{"url": "/docs/relopts/table-autovacuum-multixact-freeze-table-age/?v=14", "label": "Table option autovacuum_multixact_freeze_table_age"}, {"url": "/docs/guc/vacuum_multixact_freeze_table_age/?v=14", "label": "Global parameter vacuum_multixact_freeze_table_age"}, {"url": "/docs/sql/create-table/?v=14", "label": "CREATE TABLE"}], "release": {"ref": "Local English manual 14.24", "label": "14.24", "major": "14", "channel": "stable", "revision": "b6e7ed6d017bf1d63aae215156cde763babd657199df9fa10123733290c31260"}, "sources": [{"url": "/docs/14/sql-createtable.html#RELOPTION-AUTOVACUUM-MULTIXACT-FREEZE-TABLE-AGE", "path": "sql-createtable.html", "label": "PostgreSQL 14 English manual", "sha256": "2d92d1040e37f5d94ce279dc9f1555a720179397fcf3aa8412f5278ec1d943e8"}, {"url": "/docs/14/runtime-config-client.html#GUC-VACUUM-MULTIXACT-FREEZE-TABLE-AGE", "path": "runtime-config-client.html", "label": "Related global parameter: vacuum_multixact_freeze_table_age", "sha256": "35d48bb20f151039202a7cafbe7c4ffb109262110d62b2ab75844a3d80c2cebb"}, {"url": "/docs/14/sql-creatematerializedview.html", "path": "sql-creatematerializedview.html", "label": "PostgreSQL 14 English manual", "sha256": "50aea483dd80c78b2bd3cac754341070bfc96e436139f0137d762b3f65834c3c"}], "sections": [{"title": "TOAST inheritance", "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": "Common table storage rules", "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 70.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": "Materialized views", "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": "Related global parameter: vacuum_multixact_freeze_table_age", "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.", "VACUUM performs an aggressive scan if the table's pg_class . relminmxid field has reached the age specified by this setting. An aggressive scan differs from a regular VACUUM in that it visits every page that might contain unfrozen XIDs or MXIDs, not just those that might contain dead tuples. The default is 150 million multixacts. Although users can set this value anywhere from zero to two billion, VACUUM will silently limit the effective value to 95% of autovacuum_multixact_freeze_max_age , so that a periodic manual VACUUM has a chance to run before an anti-wraparound is launched for the table. For more information see Section 25.1.5.1 ."]}], "signature": "WITH (toast.autovacuum_multixact_freeze_table_age = value)", "description": ["Per-table value for vacuum_multixact_freeze_table_age parameter."]}, "15": {"facts": [{"label": "Applies to", "value": "TOAST tables"}, {"label": "Value type", "value": "integer"}], "related": [{"url": "/docs/relopts/table-autovacuum-multixact-freeze-table-age/?v=15", "label": "Table option autovacuum_multixact_freeze_table_age"}, {"url": "/docs/guc/vacuum_multixact_freeze_table_age/?v=15", "label": "Global parameter vacuum_multixact_freeze_table_age"}, {"url": "/docs/sql/create-table/?v=15", "label": "CREATE TABLE"}], "release": {"ref": "Local English manual 15.19", "label": "15.19", "major": "15", "channel": "stable", "revision": "643ecd492fa284d4d55861f15cbd7c0c7451abce96c8d56485bb2729caba37d5"}, "sources": [{"url": "/docs/15/sql-createtable.html#RELOPTION-AUTOVACUUM-MULTIXACT-FREEZE-TABLE-AGE", "path": "sql-createtable.html", "label": "PostgreSQL 15 English manual", "sha256": "dcb246be9d6131c7227ccde6745458865a0c97ac4c8891c2cbea73a30769d6df"}, {"url": "/docs/15/runtime-config-client.html#GUC-VACUUM-MULTIXACT-FREEZE-TABLE-AGE", "path": "runtime-config-client.html", "label": "Related global parameter: vacuum_multixact_freeze_table_age", "sha256": "fdcf588ddeeac62758840aa3b8d6ead7e37e1b0c72795e339f67db5b23509462"}, {"url": "/docs/15/sql-creatematerializedview.html", "path": "sql-creatematerializedview.html", "label": "PostgreSQL 15 English manual", "sha256": "9ce92d3a1afc7c70db12b6e3c2f163e2539cf86dbf0f1e9e6c44035b88bb10f7"}], "sections": [{"title": "TOAST inheritance", "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": "Common table storage rules", "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 73.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": "Materialized views", "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": "Related global parameter: vacuum_multixact_freeze_table_age", "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.", "VACUUM performs an aggressive scan if the table's pg_class . relminmxid field has reached the age specified by this setting. An aggressive scan differs from a regular VACUUM in that it visits every page that might contain unfrozen XIDs or MXIDs, not just those that might contain dead tuples. The default is 150 million multixacts. Although users can set this value anywhere from zero to two billion, VACUUM will silently limit the effective value to 95% of autovacuum_multixact_freeze_max_age , so that a periodic manual VACUUM has a chance to run before an anti-wraparound is launched for the table. For more information see Section 25.1.5.1 ."]}], "signature": "WITH (toast.autovacuum_multixact_freeze_table_age = value)", "description": ["Per-table value for vacuum_multixact_freeze_table_age parameter."]}, "16": {"facts": [{"label": "Applies to", "value": "TOAST tables"}, {"label": "Value type", "value": "integer"}], "related": [{"url": "/docs/relopts/table-autovacuum-multixact-freeze-table-age/?v=16", "label": "Table option autovacuum_multixact_freeze_table_age"}, {"url": "/docs/guc/vacuum_multixact_freeze_table_age/?v=16", "label": "Global parameter vacuum_multixact_freeze_table_age"}, {"url": "/docs/sql/create-table/?v=16", "label": "CREATE TABLE"}], "release": {"ref": "Local English manual 16.15", "label": "16.15", "major": "16", "channel": "stable", "revision": "0080d7d37081f27216dc4aa4f6ad85ea24c0c0441e702e6d0b190a339fd76f62"}, "sources": [{"url": "/docs/16/sql-createtable.html#RELOPTION-AUTOVACUUM-MULTIXACT-FREEZE-TABLE-AGE", "path": "sql-createtable.html", "label": "PostgreSQL 16 English manual", "sha256": "dde6108abda6f7358eeccc6867eb68f5ca601329ea3f50bc3d5b728c944a65a8"}, {"url": "/docs/16/runtime-config-client.html#GUC-VACUUM-MULTIXACT-FREEZE-TABLE-AGE", "path": "runtime-config-client.html", "label": "Related global parameter: vacuum_multixact_freeze_table_age", "sha256": "e7e096464bd87b0bfc06652cdbbdd175f7a0e955207580049eae2ee394566b20"}, {"url": "/docs/16/sql-creatematerializedview.html", "path": "sql-creatematerializedview.html", "label": "PostgreSQL 16 English manual", "sha256": "1a7ac648e9e3a49d0eab9de3b1214e1c64a16fc84fbee4c78c9f825b2c30af25"}], "sections": [{"title": "TOAST inheritance", "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": "Common table storage rules", "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 73.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": "Materialized views", "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": "Related global parameter: vacuum_multixact_freeze_table_age", "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.", "VACUUM performs an aggressive scan if the table's pg_class . relminmxid field has reached the age specified by this setting. An aggressive scan differs from a regular VACUUM in that it visits every page that might contain unfrozen XIDs or MXIDs, not just those that might contain dead tuples. The default is 150 million multixacts. Although users can set this value anywhere from zero to two billion, VACUUM will silently limit the effective value to 95% of autovacuum_multixact_freeze_max_age , so that a periodic manual VACUUM has a chance to run before an anti-wraparound is launched for the table. For more information see Section 25.1.5.1 ."]}], "signature": "WITH (toast.autovacuum_multixact_freeze_table_age = value)", "description": ["Per-table value for vacuum_multixact_freeze_table_age parameter."]}, "17": {"facts": [{"label": "Applies to", "value": "TOAST tables"}, {"label": "Value type", "value": "integer"}], "related": [{"url": "/docs/relopts/table-autovacuum-multixact-freeze-table-age/?v=17", "label": "Table option autovacuum_multixact_freeze_table_age"}, {"url": "/docs/guc/vacuum_multixact_freeze_table_age/?v=17", "label": "Global parameter vacuum_multixact_freeze_table_age"}, {"url": "/docs/sql/create-table/?v=17", "label": "CREATE TABLE"}], "release": {"ref": "Local English manual 17.11", "label": "17.11", "major": "17", "channel": "stable", "revision": "440f894c3464e7cb4fedc9846b948ca21cd2ffcef1697ff56a28eb641ee7c3d8"}, "sources": [{"url": "/docs/17/sql-createtable.html#RELOPTION-AUTOVACUUM-MULTIXACT-FREEZE-TABLE-AGE", "path": "sql-createtable.html", "label": "PostgreSQL 17 English manual", "sha256": "97385c16a0ff155ad89fe616bb074bf0a8328bcb21f5e64a7a6a0a03ddb1f4ef"}, {"url": "/docs/17/runtime-config-client.html#GUC-VACUUM-MULTIXACT-FREEZE-TABLE-AGE", "path": "runtime-config-client.html", "label": "Related global parameter: vacuum_multixact_freeze_table_age", "sha256": "e7ba41a33997d251c23f06ccf17978bf1481db92a2c607026f59af86c25d6f50"}, {"url": "/docs/17/sql-creatematerializedview.html", "path": "sql-creatematerializedview.html", "label": "PostgreSQL 17 English manual", "sha256": "88a9853b1cf1df2e9e468f5ef51e6f1932ffd000b37c298027a7cdef9bf0461f"}], "sections": [{"title": "TOAST inheritance", "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": "Common table storage rules", "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 65.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": "Materialized views", "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": "Related global parameter: vacuum_multixact_freeze_table_age", "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.", "VACUUM performs an aggressive scan if the table's pg_class . relminmxid field has reached the age specified by this setting. An aggressive scan differs from a regular VACUUM in that it visits every page that might contain unfrozen XIDs or MXIDs, not just those that might contain dead tuples. The default is 150 million multixacts. Although users can set this value anywhere from zero to two billion, VACUUM will silently limit the effective value to 95% of autovacuum_multixact_freeze_max_age , so that a periodic manual VACUUM has a chance to run before an anti-wraparound is launched for the table. For more information see Section 24.1.5.1 ."]}], "signature": "WITH (toast.autovacuum_multixact_freeze_table_age = value)", "description": ["Per-table value for vacuum_multixact_freeze_table_age parameter."]}, "18": {"facts": [{"label": "Applies to", "value": "TOAST tables"}, {"label": "Value type", "value": "integer"}], "related": [{"url": "/docs/relopts/table-autovacuum-multixact-freeze-table-age/?v=18", "label": "Table option autovacuum_multixact_freeze_table_age"}, {"url": "/docs/guc/vacuum_multixact_freeze_table_age/?v=18", "label": "Global parameter vacuum_multixact_freeze_table_age"}, {"url": "/docs/sql/create-table/?v=18", "label": "CREATE TABLE"}], "release": {"ref": "Local English manual 18.6", "label": "18.6", "major": "18", "channel": "stable", "revision": "eb6c2292fdf28e1b4635ab478eec3919411cdf4a6c07553387870e26201f3744"}, "sources": [{"url": "/docs/18/sql-createtable.html#RELOPTION-AUTOVACUUM-MULTIXACT-FREEZE-TABLE-AGE", "path": "sql-createtable.html", "label": "PostgreSQL 18 English manual", "sha256": "b4d703391fe1102d0e02bd6769bef928513eb7a5542f38f7448fc77fe69e0d5b"}, {"url": "/docs/18/runtime-config-vacuum.html#GUC-VACUUM-MULTIXACT-FREEZE-TABLE-AGE", "path": "runtime-config-vacuum.html", "label": "Related global parameter: vacuum_multixact_freeze_table_age", "sha256": "7047f1fa9138b97f1812532f8a905fa7479451dfd64655e029a7d387b20b22e4"}, {"url": "/docs/18/sql-creatematerializedview.html", "path": "sql-creatematerializedview.html", "label": "PostgreSQL 18 English manual", "sha256": "bd8a6710c9f133afee191eb0ec345ef8c54bb54db2242621d8cb683c783a8b18"}], "sections": [{"title": "TOAST inheritance", "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": "Common table storage rules", "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": "Materialized views", "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": "Related global parameter: vacuum_multixact_freeze_table_age", "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.", "VACUUM performs an aggressive scan if the table's pg_class . relminmxid field has reached the age specified by this setting. An aggressive scan differs from a regular VACUUM in that it visits every page that might contain unfrozen XIDs or MXIDs, not just those that might contain dead tuples. The default is 150 million multixacts. Although users can set this value anywhere from zero to two billion, VACUUM will silently limit the effective value to 95% of autovacuum_multixact_freeze_max_age , so that a periodic manual VACUUM has a chance to run before an anti-wraparound is launched for the table. For more information see Section 24.1.5.1 ."]}], "signature": "WITH (toast.autovacuum_multixact_freeze_table_age = value)", "description": ["Per-table value for vacuum_multixact_freeze_table_age parameter."]}, "19": {"facts": [{"label": "Applies to", "value": "TOAST tables"}, {"label": "Value type", "value": "integer"}], "related": [{"url": "/docs/relopts/table-autovacuum-multixact-freeze-table-age/?v=19", "label": "Table option autovacuum_multixact_freeze_table_age"}, {"url": "/docs/guc/vacuum_multixact_freeze_table_age/?v=19", "label": "Global parameter vacuum_multixact_freeze_table_age"}, {"url": "/docs/sql/create-table/?v=19", "label": "CREATE TABLE"}], "release": {"ref": "Local English manual 19 beta 4", "label": "19 beta 4", "major": "19", "channel": "preview", "revision": "df6d20830d1a09734a2db6ffc3a6138ce80e669294e56a30f6b5d4a89d81aef1"}, "sources": [{"url": "/docs/19/sql-createtable.html#RELOPTION-AUTOVACUUM-MULTIXACT-FREEZE-TABLE-AGE", "path": "sql-createtable.html", "label": "PostgreSQL 19 English manual", "sha256": "75f290d105bd0e76c798f124b1eed4ad1e871c8a1d36c35f0db9d38fbb7209f8"}, {"url": "/docs/19/runtime-config-vacuum.html#GUC-VACUUM-MULTIXACT-FREEZE-TABLE-AGE", "path": "runtime-config-vacuum.html", "label": "Related global parameter: vacuum_multixact_freeze_table_age", "sha256": "b4467324eaf7f51ab3a3086893b4db67d319aa05eb2cc51a6646a2085ff2b78e"}, {"url": "/docs/19/sql-creatematerializedview.html", "path": "sql-creatematerializedview.html", "label": "PostgreSQL 19 English manual", "sha256": "83626ff1539571da05619161c2d806590cac53ae060cea60018c6f63c6c02bf6"}], "sections": [{"title": "TOAST inheritance", "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": "Common table storage rules", "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": "Materialized views", "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": "Related global parameter: vacuum_multixact_freeze_table_age", "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.", "VACUUM performs an aggressive scan if the table's pg_class . relminmxid field has reached the age specified by this setting. An aggressive scan differs from a regular VACUUM in that it visits every page that might contain unfrozen XIDs or MXIDs, not just those that might contain dead tuples. The default is 150 million multixacts. Although users can set this value anywhere from zero to two billion, VACUUM will silently limit the effective value to 95% of autovacuum_multixact_freeze_max_age , so that a periodic manual VACUUM has a chance to run before an anti-wraparound is launched for the table. For more information see Section 24.1.5.1 ."]}], "signature": "WITH (toast.autovacuum_multixact_freeze_table_age = value)", "description": ["Per-table value for vacuum_multixact_freeze_table_age parameter."]}, "20": {"facts": [{"label": "Applies to", "value": "TOAST tables"}, {"label": "Value type", "value": "integer"}], "related": [{"url": "/docs/relopts/table-autovacuum-multixact-freeze-table-age/?v=20", "label": "Table option autovacuum_multixact_freeze_table_age"}, {"url": "/docs/guc/vacuum_multixact_freeze_table_age/?v=20", "label": "Global parameter vacuum_multixact_freeze_table_age"}, {"url": "/docs/sql/create-table/?v=20", "label": "CREATE TABLE"}], "release": {"ref": "2c10c2ce4d7bcd57543a49ab402af02a39724e0a", "label": "20 devel", "major": "20", "channel": "devel", "revision": "ca199fbaaf6c4bd29cd5a98beaf34d9f4141c15d2f94d1d0202f3204ef18d09f"}, "sources": [{"url": "/docs/devel/sql-createtable.html#RELOPTION-AUTOVACUUM-MULTIXACT-FREEZE-TABLE-AGE", "path": "sql-createtable.html", "label": "PostgreSQL 20 English manual", "sha256": "5241bd673de4e7a8fec7db6fa2a3a50d8368965206170725c4efd15d64c3fbf2"}, {"url": "/docs/devel/runtime-config-vacuum.html#GUC-VACUUM-MULTIXACT-FREEZE-TABLE-AGE", "path": "runtime-config-vacuum.html", "label": "Related global parameter: vacuum_multixact_freeze_table_age", "sha256": "30e406323d744a69a54900ecb606fcabcf5c63c344644b82f72a45f8e0d9265d"}, {"url": "/docs/devel/sql-creatematerializedview.html", "path": "sql-creatematerializedview.html", "label": "PostgreSQL 20 English manual", "sha256": "2870e714f1d3ef3bb692310424bb0e8fc1905c7b4a46317c5be883c70daa90c2"}], "sections": [{"title": "TOAST inheritance", "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": "Common table storage rules", "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": "Materialized views", "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": "Related global parameter: vacuum_multixact_freeze_table_age", "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.", "VACUUM performs an aggressive scan if the table's pg_class . relminmxid field has reached the age specified by this setting. An aggressive scan differs from a regular VACUUM in that it visits every page that might contain unfrozen XIDs or MXIDs, not just those that might contain dead tuples. The default is 150 million multixacts. Although users can set this value anywhere from zero to two billion, VACUUM will silently limit the effective value to 95% of autovacuum_multixact_freeze_max_age , so that a periodic manual VACUUM has a chance to run before an anti-wraparound is launched for the table. For more information see Section 24.1.5.1 ."]}], "signature": "WITH (toast.autovacuum_multixact_freeze_table_age = value)", "description": ["Per-table value for vacuum_multixact_freeze_table_age parameter."]}}, "content_hash": "d7a51f9d521ee4a43f27486c322b63023162884dd126b1c1a94ccad8be09727e", "imported_at": "2026-09-27T09:57:58.998"}, "snapshot": {"facts": [{"label": "Applies to", "value": "TOAST tables"}, {"label": "Value type", "value": "integer"}], "related": [{"url": "/docs/relopts/table-autovacuum-multixact-freeze-table-age/?v=18", "label": "Table option autovacuum_multixact_freeze_table_age"}, {"url": "/docs/guc/vacuum_multixact_freeze_table_age/?v=18", "label": "Global parameter vacuum_multixact_freeze_table_age"}, {"url": "/docs/sql/create-table/?v=18", "label": "CREATE TABLE"}], "release": {"ref": "Local English manual 18.6", "label": "18.6", "major": "18", "channel": "stable", "revision": "eb6c2292fdf28e1b4635ab478eec3919411cdf4a6c07553387870e26201f3744"}, "sources": [{"url": "/docs/18/sql-createtable.html#RELOPTION-AUTOVACUUM-MULTIXACT-FREEZE-TABLE-AGE", "path": "sql-createtable.html", "label": "PostgreSQL 18 English manual", "sha256": "b4d703391fe1102d0e02bd6769bef928513eb7a5542f38f7448fc77fe69e0d5b"}, {"url": "/docs/18/runtime-config-vacuum.html#GUC-VACUUM-MULTIXACT-FREEZE-TABLE-AGE", "path": "runtime-config-vacuum.html", "label": "Related global parameter: vacuum_multixact_freeze_table_age", "sha256": "7047f1fa9138b97f1812532f8a905fa7479451dfd64655e029a7d387b20b22e4"}, {"url": "/docs/18/sql-creatematerializedview.html", "path": "sql-creatematerializedview.html", "label": "PostgreSQL 18 English manual", "sha256": "bd8a6710c9f133afee191eb0ec345ef8c54bb54db2242621d8cb683c783a8b18"}], "sections": [{"title": "TOAST inheritance", "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": "Common table storage rules", "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": "Materialized views", "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": "Related global parameter: vacuum_multixact_freeze_table_age", "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.", "VACUUM performs an aggressive scan if the table's pg_class . relminmxid field has reached the age specified by this setting. An aggressive scan differs from a regular VACUUM in that it visits every page that might contain unfrozen XIDs or MXIDs, not just those that might contain dead tuples. The default is 150 million multixacts. Although users can set this value anywhere from zero to two billion, VACUUM will silently limit the effective value to 95% of autovacuum_multixact_freeze_max_age , so that a periodic manual VACUUM has a chance to run before an anti-wraparound is launched for the table. For more information see Section 24.1.5.1 ."]}], "signature": "WITH (toast.autovacuum_multixact_freeze_table_age = value)", "description": ["Per-table value for vacuum_multixact_freeze_table_age parameter."]}, "comparison": {"left": "17", "right": "18", "status": "unchanged", "diff": ""}}