Search PostgreSQL documentation

autosummarizeStorage ParametersReferenceStorage Parameters · BRIN indexesDefines whether a summarization run is queued for the previous page range whenever an insertion is detected on the next one (see Section 65.5.1.1 for more details). The default is off . auto… autovacuum_analyze_scale_factorStorage ParametersReferenceStorage Parameters · Tables and materialized viewsPer-table value for autovacuum_analyze_scale_factor parameter. autovacuum_analyze_scale_factor Tables and materialized views WITH (autovacuum_analyze_scale_factor = value) Applies to Tables … autovacuum_analyze_thresholdStorage ParametersReferenceStorage Parameters · Tables and materialized viewsPer-table value for autovacuum_analyze_threshold parameter. autovacuum_analyze_threshold Tables and materialized views WITH (autovacuum_analyze_threshold = value) Applies to Tables and mater… autovacuum_enabledStorage ParametersReferenceStorage Parameters · Tables and materialized viewsEnables 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 dis… autovacuum_freeze_max_ageStorage ParametersReferenceStorage Parameters · Tables and materialized viewsPer-table value for autovacuum_freeze_max_age parameter. Note that autovacuum will ignore per-table autovacuum_freeze_max_age parameters that are larger than the system-wide setting (it can … autovacuum_freeze_min_ageStorage ParametersReferenceStorage Parameters · Tables and materialized viewsPer-table value for vacuum_freeze_min_age parameter. Note that autovacuum will ignore per-table autovacuum_freeze_min_age parameters that are larger than half the system-wide autovacuum_free… autovacuum_freeze_table_ageStorage ParametersReferenceStorage Parameters · Tables and materialized viewsPer-table value for vacuum_freeze_table_age parameter. autovacuum_freeze_table_age Tables and materialized views WITH (autovacuum_freeze_table_age = value) Applies to Tables and materialized… autovacuum_multixact_freeze_max_ageStorage ParametersReferenceStorage Parameters · Tables and materialized viewsPer-table value for autovacuum_multixact_freeze_max_age parameter. Note that autovacuum will ignore per-table autovacuum_multixact_freeze_max_age parameters that are larger than the system-w… autovacuum_multixact_freeze_min_ageStorage ParametersReferenceStorage Parameters · Tables and materialized viewsPer-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-… autovacuum_multixact_freeze_table_ageStorage ParametersReferenceStorage Parameters · Tables and materialized viewsPer-table value for vacuum_multixact_freeze_table_age parameter. autovacuum_multixact_freeze_table_age Tables and materialized views WITH (autovacuum_multixact_freeze_table_age = value) Appl… autovacuum_parallel_workersStorage ParametersReferenceStorage Parameters · Tables and materialized viewsPer-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… autovacuum_vacuum_cost_delayStorage ParametersReferenceStorage Parameters · Tables and materialized viewsPer-table value for autovacuum_vacuum_cost_delay parameter. autovacuum_vacuum_cost_delay Tables and materialized views WITH (autovacuum_vacuum_cost_delay = value) Applies to Tables and mater… autovacuum_vacuum_cost_limitStorage ParametersReferenceStorage Parameters · Tables and materialized viewsPer-table value for autovacuum_vacuum_cost_limit parameter. autovacuum_vacuum_cost_limit Tables and materialized views WITH (autovacuum_vacuum_cost_limit = value) Applies to Tables and mater… autovacuum_vacuum_insert_scale_factorStorage ParametersReferenceStorage Parameters · Tables and materialized viewsPer-table value for autovacuum_vacuum_insert_scale_factor parameter. autovacuum_vacuum_insert_scale_factor Tables and materialized views WITH (autovacuum_vacuum_insert_scale_factor = value) … autovacuum_vacuum_insert_thresholdStorage ParametersReferenceStorage Parameters · Tables and materialized viewsPer-table value for autovacuum_vacuum_insert_threshold parameter. The special value of -1 may be used to disable insert vacuums on the table. autovacuum_vacuum_insert_threshold Tables and ma… autovacuum_vacuum_max_thresholdStorage ParametersReferenceStorage Parameters · Tables and materialized viewsPer-table value for autovacuum_vacuum_max_threshold parameter. autovacuum_vacuum_max_threshold Tables and materialized views WITH (autovacuum_vacuum_max_threshold = value) Applies to Tables … autovacuum_vacuum_scale_factorStorage ParametersReferenceStorage Parameters · Tables and materialized viewsPer-table value for autovacuum_vacuum_scale_factor parameter. autovacuum_vacuum_scale_factor Tables and materialized views WITH (autovacuum_vacuum_scale_factor = value) Applies to Tables and… autovacuum_vacuum_thresholdStorage ParametersReferenceStorage Parameters · Tables and materialized viewsPer-table value for autovacuum_vacuum_threshold parameter. autovacuum_vacuum_threshold Tables and materialized views WITH (autovacuum_vacuum_threshold = value) Applies to Tables and material… bufferingStorage ParametersReferenceStorage Parameters · GiST indexesControls whether the buffered build technique described in Section 65.2.4.1 is used to build the index. With OFF buffering is disabled, with ON it is enabled, and with AUTO it is initially d… check_optionStorage ParametersReferenceStorage Parameters · View optionsThis parameter may be either local or cascaded , and is equivalent to specifying WITH [ CASCADED | LOCAL ] CHECK OPTION (see below). check_option View options This parameter may be either lo… deduplicate_itemsStorage ParametersReferenceStorage Parameters · B-tree indexesControls usage of the B-tree deduplication technique described in Section 65.1.4.3 . Set to ON or OFF to enable or disable the optimization. (Alternative spellings of ON and OFF are allowed … fastupdateStorage ParametersReferenceStorage Parameters · GIN indexesControls usage of the fast update technique described in Section 65.4.4.1 . ON enables fast update, OFF disables it. The default is ON . fastupdate GIN indexes This setting controls usage of… fillfactorStorage ParametersReferenceStorage Parameters · B-tree indexesControls how full the index method will try to pack index pages. For B-trees, leaf pages are filled to this percentage during initial index builds, and also when extending the index at the r… fillfactorStorage ParametersReferenceStorage Parameters · GiST indexesControls how full the index method will try to pack index pages. For B-trees, leaf pages are filled to this percentage during initial index builds, and also when extending the index at the r… fillfactorStorage ParametersReferenceStorage Parameters · Hash indexesControls how full the index method will try to pack index pages. For B-trees, leaf pages are filled to this percentage during initial index builds, and also when extending the index at the r… fillfactorStorage ParametersReferenceStorage Parameters · SP-GiST indexesControls how full the index method will try to pack index pages. For B-trees, leaf pages are filled to this percentage during initial index builds, and also when extending the index at the r… fillfactorStorage ParametersReferenceStorage Parameters · Tables and materialized viewsThe fillfactor for a table is a percentage between 10 and 100. 100 (complete packing) is the default. When a smaller fillfactor is specified, INSERT operations pack table pages only to the i… gin_pending_list_limitStorage ParametersReferenceStorage Parameters · GIN indexesOverrides the global setting of gin_pending_list_limit for this index. This value is specified in kilobytes. gin_pending_list_limit GIN indexes Custom gin_pending_list_limit parameter. This … log_autoanalyze_min_durationStorage ParametersReferenceStorage Parameters · Tables and materialized viewsPer-table value for log_autoanalyze_min_duration parameter. log_autoanalyze_min_duration Tables and materialized views WITH (log_autoanalyze_min_duration = value) Applies to Tables and mater… log_autovacuum_min_durationStorage ParametersReferenceStorage Parameters · Tables and materialized viewsPer-table value for log_autovacuum_min_duration parameter. log_autovacuum_min_duration Tables and materialized views WITH (log_autovacuum_min_duration = value) Applies to Tables and material… oidsStorage ParametersReferenceStorage Parameters · Table compatibility optionsThis clause specifies optional storage parameters for a table or index; see Storage Parameters below for more information. For backward-compatibility the WITH clause for a table can also inc… pages_per_rangeStorage ParametersReferenceStorage Parameters · BRIN indexesDefines the number of table blocks that make up one block range for each entry of a BRIN index (see Section 65.5.1 for more details). The default is 128 . pages_per_range BRIN indexes Define… parallel_workersStorage ParametersReferenceStorage Parameters · Tables and materialized viewsThis sets the number of workers that should be used to assist a parallel scan of this table. If not set, the system will determine a value based on the relation size. The actual number of wo… security_barrierStorage ParametersReferenceStorage Parameters · View optionsThis should be used if the view is intended to provide row-level security. See Section 39.5 for full details. security_barrier View options This should be used if the view is intended to pro… security_invokerStorage ParametersReferenceStorage Parameters · View optionsThis option causes the underlying base relations to be checked against the privileges of the user of the view rather than the view owner. See the notes below for full details. security_invok… toast.autovacuum_enabledStorage ParametersReferenceStorage Parameters · TOAST tablesEnables 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 dis… toast.autovacuum_freeze_max_ageStorage ParametersReferenceStorage Parameters · TOAST tablesPer-table value for autovacuum_freeze_max_age parameter. Note that autovacuum will ignore per-table autovacuum_freeze_max_age parameters that are larger than the system-wide setting (it can … toast.autovacuum_freeze_min_ageStorage ParametersReferenceStorage Parameters · TOAST tablesPer-table value for vacuum_freeze_min_age parameter. Note that autovacuum will ignore per-table autovacuum_freeze_min_age parameters that are larger than half the system-wide autovacuum_free… toast.autovacuum_freeze_table_ageStorage ParametersReferenceStorage Parameters · TOAST tablesPer-table value for vacuum_freeze_table_age parameter. TOAST autovacuum_freeze_table_age TOAST tables WITH (toast.autovacuum_freeze_table_age = value) Applies to TOAST tables Value type inte… toast.autovacuum_multixact_freeze_max_ageStorage ParametersReferenceStorage Parameters · TOAST tablesPer-table value for autovacuum_multixact_freeze_max_age parameter. Note that autovacuum will ignore per-table autovacuum_multixact_freeze_max_age parameters that are larger than the system-w…