{"kind": "relopts", "major": "18", "item": {"slug": "table-autovacuum-parallel-workers", "name": "autovacuum_parallel_workers", "name_zh": "autovacuum_parallel_workers", "category": "Tables and materialized views", "summary": "Not recorded in the selected version.", "aliases": ["table.autovacuum_parallel_workers"], "versions": {"19": {"facts": [{"label": "Applies to", "value": "Tables and materialized views"}, {"label": "Value type", "value": "integer"}], "related": [{"url": "/docs/guc/autovacuum_max_parallel_workers/?v=19", "label": "Global parameter autovacuum_max_parallel_workers"}, {"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-PARALLEL-WORKERS", "path": "sql-createtable.html", "label": "PostgreSQL 19 English manual", "sha256": "75f290d105bd0e76c798f124b1eed4ad1e871c8a1d36c35f0db9d38fbb7209f8"}, {"url": "/docs/19/runtime-config-vacuum.html#GUC-AUTOVACUUM-MAX-PARALLEL-WORKERS", "path": "runtime-config-vacuum.html", "label": "Related global parameter: autovacuum_max_parallel_workers", "sha256": "b4467324eaf7f51ab3a3086893b4db67d319aa05eb2cc51a6646a2085ff2b78e"}, {"url": "/docs/19/sql-creatematerializedview.html", "path": "sql-creatematerializedview.html", "label": "PostgreSQL 19 English manual", "sha256": "83626ff1539571da05619161c2d806590cac53ae060cea60018c6f63c6c02bf6"}], "sections": [{"title": "Scope", "paragraphs": ["This relation-level setting applies to the table or materialized view. Any corresponding global parameter has a separate entry."]}, {"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: autovacuum_max_parallel_workers", "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.", "Sets the maximum number of parallel workers that can be used by a single autovacuum worker to process indexes. This limit applies specifically to the index vacuuming and index cleanup phases (for the details of each autovacuum phase, please refer to Table 27.51 ). The actual number of parallel workers is further limited by max_parallel_workers . This is the per-autovacuum worker equivalent of the PARALLEL option of the VACUUM command. Setting this value to 0 disables parallel vacuum during autovacuum. The default is 0."]}], "signature": "WITH (autovacuum_parallel_workers = value)", "description": ["Per-table value for autovacuum_max_parallel_workers parameter. If -1 is specified, autovacuum_max_parallel_workers value will be used. If set to 0, parallel vacuum is disabled for this table. The default value is -1."]}, "20": {"facts": [{"label": "Applies to", "value": "Tables and materialized views"}, {"label": "Value type", "value": "integer"}], "related": [{"url": "/docs/guc/autovacuum_max_parallel_workers/?v=20", "label": "Global parameter autovacuum_max_parallel_workers"}, {"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-PARALLEL-WORKERS", "path": "sql-createtable.html", "label": "PostgreSQL 20 English manual", "sha256": "5241bd673de4e7a8fec7db6fa2a3a50d8368965206170725c4efd15d64c3fbf2"}, {"url": "/docs/devel/runtime-config-vacuum.html#GUC-AUTOVACUUM-MAX-PARALLEL-WORKERS", "path": "runtime-config-vacuum.html", "label": "Related global parameter: autovacuum_max_parallel_workers", "sha256": "30e406323d744a69a54900ecb606fcabcf5c63c344644b82f72a45f8e0d9265d"}, {"url": "/docs/devel/sql-creatematerializedview.html", "path": "sql-creatematerializedview.html", "label": "PostgreSQL 20 English manual", "sha256": "2870e714f1d3ef3bb692310424bb0e8fc1905c7b4a46317c5be883c70daa90c2"}], "sections": [{"title": "Scope", "paragraphs": ["This relation-level setting applies to the table or materialized view. Any corresponding global parameter has a separate entry."]}, {"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: autovacuum_max_parallel_workers", "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.", "Sets the maximum number of parallel workers that can be used by a single autovacuum worker to process indexes. This limit applies specifically to the index vacuuming and index cleanup phases (for the details of each autovacuum phase, please refer to Table 27.52 ). The actual number of parallel workers is further limited by max_parallel_workers . This is the per-autovacuum worker equivalent of the PARALLEL option of the VACUUM command. Setting this value to 0 disables parallel vacuum during autovacuum. The default is 0."]}], "signature": "WITH (autovacuum_parallel_workers = value)", "description": ["Per-table value for autovacuum_max_parallel_workers parameter. If -1 is specified, autovacuum_max_parallel_workers value will be used. If set to 0, parallel vacuum is disabled for this table. The default value is -1."]}}, "content_hash": "279a59438150f50a63da91e1848a2b76939a4ed9d94a20b9e5046f03797abd70", "imported_at": "2026-09-27T09:57:58.944"}, "snapshot": null, "comparison": {"left": "18", "right": "19", "status": "added", "diff": "--- PostgreSQL 18\n+++ PostgreSQL 19\n@@ -1 +1,14 @@\n-Not recorded in this version\n+{\n+  \"facts\": [\n+    {\n+      \"label\": \"Applies to\",\n+      \"value\": \"Tables and materialized views\"\n+    },\n+    {\n+      \"label\": \"Value type\",\n+      \"value\": \"integer\"\n+    }\n+  ],\n+  \"signature\": \"WITH (autovacuum_parallel_workers = value)\",\n+  \"tables\": null\n+}"}}