Search PostgreSQL documentation

toast.autovacuum_multixact_freeze_min_ageStorage ParametersReferenceStorage Parameters · TOAST tablesPer-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-… toast.autovacuum_multixact_freeze_table_ageStorage ParametersReferenceStorage Parameters · TOAST tablesPer-table value for vacuum_multixact_freeze_table_age parameter. TOAST autovacuum_multixact_freeze_table_age TOAST tables WITH (toast.autovacuum_multixact_freeze_table_age = value) Applies t… toast.autovacuum_vacuum_cost_delayStorage ParametersReferenceStorage Parameters · TOAST tablesPer-table value for autovacuum_vacuum_cost_delay parameter. TOAST autovacuum_vacuum_cost_delay TOAST tables WITH (toast.autovacuum_vacuum_cost_delay = value) Applies to TOAST tables Value ty… toast.autovacuum_vacuum_cost_limitStorage ParametersReferenceStorage Parameters · TOAST tablesPer-table value for autovacuum_vacuum_cost_limit parameter. TOAST autovacuum_vacuum_cost_limit TOAST tables WITH (toast.autovacuum_vacuum_cost_limit = value) Applies to TOAST tables Value ty… toast.autovacuum_vacuum_insert_scale_factorStorage ParametersReferenceStorage Parameters · TOAST tablesPer-table value for autovacuum_vacuum_insert_scale_factor parameter. TOAST autovacuum_vacuum_insert_scale_factor TOAST tables WITH (toast.autovacuum_vacuum_insert_scale_factor = value) Appli… toast.autovacuum_vacuum_insert_thresholdStorage ParametersReferenceStorage Parameters · TOAST tablesPer-table value for autovacuum_vacuum_insert_threshold parameter. The special value of -1 may be used to disable insert vacuums on the table. TOAST autovacuum_vacuum_insert_threshold TOAST t… toast.autovacuum_vacuum_max_thresholdStorage ParametersReferenceStorage Parameters · TOAST tablesPer-table value for autovacuum_vacuum_max_threshold parameter. TOAST autovacuum_vacuum_max_threshold TOAST tables WITH (toast.autovacuum_vacuum_max_threshold = value) Applies to TOAST tables… toast.autovacuum_vacuum_scale_factorStorage ParametersReferenceStorage Parameters · TOAST tablesPer-table value for autovacuum_vacuum_scale_factor parameter. TOAST autovacuum_vacuum_scale_factor TOAST tables WITH (toast.autovacuum_vacuum_scale_factor = value) Applies to TOAST tables Va… toast.autovacuum_vacuum_thresholdStorage ParametersReferenceStorage Parameters · TOAST tablesPer-table value for autovacuum_vacuum_threshold parameter. TOAST autovacuum_vacuum_threshold TOAST tables WITH (toast.autovacuum_vacuum_threshold = value) Applies to TOAST tables Value type … toast.log_autovacuum_min_durationStorage ParametersReferenceStorage Parameters · TOAST tablesPer-table value for log_autovacuum_min_duration parameter. TOAST log_autovacuum_min_duration TOAST tables WITH (toast.log_autovacuum_min_duration = value) Applies to TOAST tables Value type … toast.vacuum_index_cleanupStorage ParametersReferenceStorage Parameters · TOAST tablesForces or disables index cleanup when VACUUM is run on this table. The default value is AUTO . With OFF , index cleanup is disabled, with ON it is enabled, and with AUTO a decision is made d… toast.vacuum_max_eager_freeze_failure_rateStorage ParametersReferenceStorage Parameters · TOAST tablesPer-table value for vacuum_max_eager_freeze_failure_rate parameter. TOAST vacuum_max_eager_freeze_failure_rate TOAST tables WITH (toast.vacuum_max_eager_freeze_failure_rate = value) Applies … toast.vacuum_truncateStorage ParametersReferenceStorage Parameters · TOAST tablesPer-table value for vacuum_truncate parameter. The TRUNCATE parameter of VACUUM , if specified, overrides the value of this option. TOAST vacuum_truncate TOAST tables Enables or disables vac… toast_tuple_targetStorage ParametersReferenceStorage Parameters · Tables and materialized viewsThe toast_tuple_target specifies the minimum tuple length required before we try to compress and/or move long column values into TOAST tables, and is also the target length we try to reduce … toast_value_typeStorage ParametersReferenceStorage Parameters · Tables and materialized viewsSpecifies the attribute type of chunk_id to use when creating a TOAST relation for this table. The default is oid ; oid8 assigns oid8 instead, which allows a larger number of distinct TOAST … user_catalog_tableStorage ParametersReferenceStorage Parameters · Tables and materialized viewsDeclare the table as an additional catalog table for purposes of logical replication. See Section 47.7.2 for details. This parameter cannot be set for TOAST tables. user_catalog_table Tables… vacuum_cleanup_index_scale_factorStorage ParametersReferenceStorage Parameters · B-tree indexesPer-index value for vacuum_cleanup_index_scale_factor . vacuum_cleanup_index_scale_factor B-tree indexes WITH (vacuum_cleanup_index_scale_factor = value) Applies to B-tree indexes Value type… vacuum_index_cleanupStorage ParametersReferenceStorage Parameters · Tables and materialized viewsForces or disables index cleanup when VACUUM is run on this table. The default value is AUTO . With OFF , index cleanup is disabled, with ON it is enabled, and with AUTO a decision is made d… vacuum_max_eager_freeze_failure_rateStorage ParametersReferenceStorage Parameters · Tables and materialized viewsPer-table value for vacuum_max_eager_freeze_failure_rate parameter. vacuum_max_eager_freeze_failure_rate Tables and materialized views WITH (vacuum_max_eager_freeze_failure_rate = value) App… vacuum_truncateStorage ParametersReferenceStorage Parameters · Tables and materialized viewsPer-table value for vacuum_truncate parameter. The TRUNCATE parameter of VACUUM , if specified, overrides the value of this option. vacuum_truncate Tables and materialized views Enables or d…