toast.autovacuum_enabled

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 .

Applies to

TOAST tables

Value type

boolean

Usage

WITH (toast.autovacuum_enabled = value)

TOAST inheritance

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.

Common table storage rules

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.

Materialized views

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.

Related entries

• Table option autovacuum_enabled
• CREATE TABLE

Documentation and source

• PostgreSQL 18 English manual
• PostgreSQL 18 English manual

Related entries

• toast.autovacuum_freeze_max_ageTOAST autovacuum_freeze_max_age
• toast.autovacuum_freeze_min_ageTOAST autovacuum_freeze_min_age
• toast.autovacuum_freeze_table_ageTOAST autovacuum_freeze_table_age
• toast.autovacuum_multixact_freeze_max_ageTOAST autovacuum_multixact_freeze_max_age
• toast.autovacuum_multixact_freeze_min_ageTOAST autovacuum_multixact_freeze_min_age
• toast.autovacuum_multixact_freeze_table_ageTOAST autovacuum_multixact_freeze_table_age
• toast.autovacuum_vacuum_cost_delayTOAST autovacuum_vacuum_cost_delay
• toast.autovacuum_vacuum_cost_limitTOAST autovacuum_vacuum_cost_limit
• toast.autovacuum_vacuum_insert_scale_factorTOAST autovacuum_vacuum_insert_scale_factor
• toast.autovacuum_vacuum_insert_thresholdTOAST autovacuum_vacuum_insert_threshold
• toast.autovacuum_vacuum_max_thresholdTOAST autovacuum_vacuum_max_threshold
• toast.autovacuum_vacuum_scale_factorTOAST autovacuum_vacuum_scale_factor