{"Entry":{"collection":"relopts","key":"toast-autovacuum-enabled","name":"toast.autovacuum_enabled","aliases":["autovacuum_enabled"],"metadata":{"aliases":["autovacuum_enabled"],"category":"TOAST tables","content_hash":"e1bf908b12d5f1ed6cbf5a2558d3e5a8c379710bdd0d7be590926a416ac40491","derived_content_hash":"6078fd2d4d4c29f17bf18da4467a246f67205f9828dc318ec2df4bc9cdc236d4","imported_at":"2026-09-30T17:44:22.282134+08:00","name":"toast.autovacuum_enabled","name_zh":"TOAST autovacuum_enabled","repair_provenance":{"original_source_revision":"","receipt_sha256":"388667c2fd235ff7de1446309f90c8d97f1d662a682b869b7e6525d135498fcf","repair":"wiki-repair-20261023"},"slug":"toast-autovacuum-enabled","source_rev":"wiki-repair-20261023:17686d4885f0d53209e1c877c6d6e748ac640d8aa938093bd59917b49312d86f","summary":"Enables or disables the autovacuum daemon for a particular table. If true, the autovacuum daemon will perform automatic VACUUM and/or ANALYZE operations on this table following the rules discussed in Section 24.1.6 . If false, this table will not be autovacuumed, except to prevent transaction ID wraparound. See Section 24.1.5 for more about wraparound prevention. Note that the autovacuum daemon does not run at all (except to prevent transaction ID wraparound) if the autovacuum parameter is false; setting individual tables' storage parameters does not override that. Therefore there is seldom much point in explicitly setting this storage parameter to true , only to false ."}},"Definition":{"Collection":"relopts","Key":"toast-autovacuum-enabled","SourceDatabase":"center","Version":"18","SourceTable":"relopt","SourceKey":"toast-autovacuum-enabled","SourceRevision":"eb6c2292fdf28e1b4635ab478eec3919411cdf4a6c07553387870e26201f3744","Facts":{"description":["Enables or disables the autovacuum daemon for a particular table. If true, the autovacuum daemon will perform automatic VACUUM and/or ANALYZE operations on this table following the rules discussed in Section 24.1.6 . If false, this table will not be autovacuumed, except to prevent transaction ID wraparound. See Section 24.1.5 for more about wraparound prevention. Note that the autovacuum daemon does not run at all (except to prevent transaction ID wraparound) if the autovacuum parameter is false; setting individual tables' storage parameters does not override that. Therefore there is seldom much point in explicitly setting this storage parameter to true , only to false ."],"description_zh":"为特定表启用或禁用自动清理守护进程。如果为真，自动清理守护进程将按照第 24.1.6 节中讨论的规则，在该表上执行自动 VACUUM 和/或 ANALYZE 操作。如果为假，则该表不会被自动清理，但为了防止事务 ID 回卷，仍可能对其执行自动清理。有关回卷防护的更多信息，见第 24.1.5 节。注意，如果 autovacuum 参数为假，则自动清理守护进程根本不会运行（防止事务 ID 回卷的情况除外）；为单独表设置存储参数也不会覆盖这一点。因此，显式将此存储参数设为 true 往往意义不大，设为 false 才更有用。","description_zh_html":"\u003cp\u003e\n      为特定表启用或禁用自动清理守护进程。如果为真，自动清理守护进程将按照\u003ca class=\"xref\" href=\"/zh/docs/18/routine-vacuuming.html#AUTOVACUUM\" title=\"24.1.6. 自动清理守护进程\"\u003e第 24.1.6 节\u003c/a\u003e中讨论的规则，在该表上执行自动\n      \u003ccode class=\"command\"\u003eVACUUM\u003c/code\u003e 和/或 \u003ccode class=\"command\"\u003eANALYZE\u003c/code\u003e 操作。如果为假，则该表不会被自动清理，但为了防止事务 ID 回卷，仍可能对其执行自动清理。有关回卷防护的更多信息，见\u003ca class=\"xref\" href=\"/zh/docs/18/routine-vacuuming.html#VACUUM-FOR-WRAPAROUND\" title=\"24.1.5. 防止事务 ID 回卷失败\"\u003e第 24.1.5 节\u003c/a\u003e。注意，如果 \u003ca class=\"xref\" href=\"/zh/docs/18/runtime-config-vacuum.html#GUC-AUTOVACUUM\"\u003eautovacuum\u003c/a\u003e 参数为假，则自动清理守护进程根本不会运行（防止事务 ID 回卷的情况除外）；为单独表设置存储参数也不会覆盖这一点。因此，显式将此存储参数设为 \u003ccode class=\"literal\"\u003etrue\u003c/code\u003e 往往意义不大，设为 \u003ccode class=\"literal\"\u003efalse\u003c/code\u003e 才更有用。\n     \u003c/p\u003e","facts":[{"label":"Applies to","value":"TOAST tables"},{"label":"Value type","value":"boolean"}],"related":[{"label":"Table option autovacuum_enabled","url":"/wiki/relopts/table-autovacuum-enabled/?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"}],"signature":"WITH (toast.autovacuum_enabled = value)","sources":[{"label":"PostgreSQL 18 English manual","path":"sql-createtable.html","sha256":"b4d703391fe1102d0e02bd6769bef928513eb7a5542f38f7448fc77fe69e0d5b","url":"/docs/18/sql-createtable.html#RELOPTION-AUTOVACUUM-ENABLED"},{"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":"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-ENABLED"},{"label":"PostgreSQL 18 English manual","path":"sql-creatematerializedview.html","sha256":"bd8a6710c9f133afee191eb0ec345ef8c54bb54db2242621d8cb683c783a8b18","url":"/docs/18/sql-creatematerializedview.html"}]},"MeasuredEvidence":{}},"Text":{"Collection":"relopts","Key":"toast-autovacuum-enabled","SourceDatabase":"center","Version":"18","Locale":"en","Title":"toast.autovacuum_enabled","Summary":"Enables or disables the autovacuum daemon for a particular table. If true, the autovacuum daemon will perform automatic VACUUM and/or ANALYZE operations on this table following the rules discussed in Section 24.1.6 . If false, this table will not be autovacuumed, except to prevent transaction ID wraparound. See Section 24.1.5 for more about wraparound prevention. Note that the autovacuum daemon does not run at all (except to prevent transaction ID wraparound) if the autovacuum parameter is false; setting individual tables' storage parameters does not override that. Therefore there is seldom much point in explicitly setting this storage parameter to true , only to false .","BodyHTML":"\u003cp\u003eEnables or disables the autovacuum daemon for a particular table. If true, the autovacuum daemon will perform automatic VACUUM and/or ANALYZE operations on this table following the rules discussed in Section 24.1.6 . If false, this table will not be autovacuumed, except to prevent transaction ID wraparound. See Section 24.1.5 for more about wraparound prevention. Note that the autovacuum daemon does not run at all (except to prevent transaction ID wraparound) if the autovacuum parameter is false; setting individual tables\u0026#39; storage parameters does not override that. Therefore there is seldom much point in explicitly setting this storage parameter to true , only to false .\u003c/p\u003e","SourceRevision":"eb6c2292fdf28e1b4635ab478eec3919411cdf4a6c07553387870e26201f3744","ContentHash":"3890d8b97e48f70a433a72a3f4c2a8d08f23e850c0412e0dab6c9e4e9e110f9c","Payload":{"description":["Enables or disables the autovacuum daemon for a particular table. If true, the autovacuum daemon will perform automatic VACUUM and/or ANALYZE operations on this table following the rules discussed in Section 24.1.6 . If false, this table will not be autovacuumed, except to prevent transaction ID wraparound. See Section 24.1.5 for more about wraparound prevention. Note that the autovacuum daemon does not run at all (except to prevent transaction ID wraparound) if the autovacuum parameter is false; setting individual tables' storage parameters does not override that. Therefore there is seldom much point in explicitly setting this storage parameter to true , only to false ."],"related":[{"label":"Table option autovacuum_enabled","url":"/wiki/relopts/table-autovacuum-enabled/?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"}]}},"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}