Wiki / Storage Parameters
Storage Parameters
Compare versionsPer-object options for tables, TOAST, indexes and views, extracted from each version of the English manual.
Reading PostgreSQL 18.6.
60 entries; 56 recorded in PostgreSQL 18.6.
-
deduplicate_items B-tree indexes
deduplicate_items
Controls 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 as described in Section 19.1 .) The default is ON .
-
fillfactor B-tree indexes
B-tree indexes fillfactor
Controls 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 right (adding new largest key values). If pages subsequently…
-
vacuum_cleanup_index_scale_factor
Not recorded in the selected version.
-
autosummarize BRIN indexes
autosummarize
Defines 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 .
-
pages_per_range BRIN indexes
pages_per_range
Defines 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 .
-
fastupdate GIN indexes
fastupdate
Controls usage of the fast update technique described in Section 65.4.4.1 . ON enables fast update, OFF disables it. The default is ON .
-
gin_pending_list_limit GIN indexes
gin_pending_list_limit
Overrides the global setting of gin_pending_list_limit for this index. This value is specified in kilobytes.
-
buffering GiST indexes
buffering
Controls 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 disabled, but is turned on on-the-fly once the index size re…
-
fillfactor GiST indexes
GiST indexes fillfactor
Controls 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 right (adding new largest key values). If pages subsequently…
-
fillfactor Hash indexes
Hash indexes fillfactor
Controls 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 right (adding new largest key values). If pages subsequently…
-
fillfactor SP-GiST indexes
SP-GiST indexes fillfactor
Controls 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 right (adding new largest key values). If pages subsequently…
-
toast.autovacuum_enabled TOAST tables
TOAST autovacuum_enabled
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…
-
toast.autovacuum_freeze_max_age TOAST tables
TOAST autovacuum_freeze_max_age
Per-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 only be set smaller).
-
toast.autovacuum_freeze_min_age TOAST tables
TOAST autovacuum_freeze_min_age
Per-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_freeze_max_age setting.
-
toast.autovacuum_freeze_table_age TOAST tables
TOAST autovacuum_freeze_table_age
Per-table value for vacuum_freeze_table_age parameter.
-
toast.autovacuum_multixact_freeze_max_age TOAST tables
TOAST autovacuum_multixact_freeze_max_age
Per-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-wide setting (it can only be set smaller).
-
toast.autovacuum_multixact_freeze_min_age TOAST tables
TOAST autovacuum_multixact_freeze_min_age
Per-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-wide autovacuum_multixact_freeze_max_age setting.
-
toast.autovacuum_multixact_freeze_table_age TOAST tables
TOAST autovacuum_multixact_freeze_table_age
Per-table value for vacuum_multixact_freeze_table_age parameter.
-
toast.autovacuum_vacuum_cost_delay TOAST tables
TOAST autovacuum_vacuum_cost_delay
Per-table value for autovacuum_vacuum_cost_delay parameter.
-
toast.autovacuum_vacuum_cost_limit TOAST tables
TOAST autovacuum_vacuum_cost_limit
Per-table value for autovacuum_vacuum_cost_limit parameter.
-
toast.autovacuum_vacuum_insert_scale_factor TOAST tables
TOAST autovacuum_vacuum_insert_scale_factor
Per-table value for autovacuum_vacuum_insert_scale_factor parameter.
-
toast.autovacuum_vacuum_insert_threshold TOAST tables
TOAST autovacuum_vacuum_insert_threshold
Per-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_max_threshold TOAST tables
TOAST autovacuum_vacuum_max_threshold
Per-table value for autovacuum_vacuum_max_threshold parameter.
-
toast.autovacuum_vacuum_scale_factor TOAST tables
TOAST autovacuum_vacuum_scale_factor
Per-table value for autovacuum_vacuum_scale_factor parameter.
-
toast.autovacuum_vacuum_threshold TOAST tables
TOAST autovacuum_vacuum_threshold
Per-table value for autovacuum_vacuum_threshold parameter.
-
toast.log_autovacuum_min_duration TOAST tables
TOAST log_autovacuum_min_duration
Per-table value for log_autovacuum_min_duration parameter.
-
toast.vacuum_index_cleanup TOAST tables
TOAST vacuum_index_cleanup
Forces 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 dynamically, each time VACUUM runs. The dynamic behavior all…
-
toast.vacuum_max_eager_freeze_failure_rate TOAST tables
TOAST vacuum_max_eager_freeze_failure_rate
Per-table value for vacuum_max_eager_freeze_failure_rate parameter.
-
toast.vacuum_truncate TOAST tables
TOAST vacuum_truncate
Per-table value for vacuum_truncate parameter. The TRUNCATE parameter of VACUUM , if specified, overrides the value of this option.
-
oids Table compatibility options
oids
This 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 include OIDS=FALSE to specify that rows of the new table shoul…
-
autovacuum_analyze_scale_factor Tables and materialized views
autovacuum_analyze_scale_factor
Per-table value for autovacuum_analyze_scale_factor parameter.
-
autovacuum_analyze_threshold Tables and materialized views
autovacuum_analyze_threshold
Per-table value for autovacuum_analyze_threshold parameter.
-
autovacuum_enabled Tables and materialized views
autovacuum_enabled
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…
-
autovacuum_freeze_max_age Tables and materialized views
autovacuum_freeze_max_age
Per-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 only be set smaller).
-
autovacuum_freeze_min_age Tables and materialized views
autovacuum_freeze_min_age
Per-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_freeze_max_age setting.
-
autovacuum_freeze_table_age Tables and materialized views
autovacuum_freeze_table_age
Per-table value for vacuum_freeze_table_age parameter.
-
autovacuum_multixact_freeze_max_age Tables and materialized views
autovacuum_multixact_freeze_max_age
Per-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-wide setting (it can only be set smaller).
-
autovacuum_multixact_freeze_min_age Tables and materialized views
autovacuum_multixact_freeze_min_age
Per-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-wide autovacuum_multixact_freeze_max_age setting.
-
autovacuum_multixact_freeze_table_age Tables and materialized views
autovacuum_multixact_freeze_table_age
Per-table value for vacuum_multixact_freeze_table_age parameter.
-
autovacuum_parallel_workers
Not recorded in the selected version.
-
autovacuum_vacuum_cost_delay Tables and materialized views
autovacuum_vacuum_cost_delay
Per-table value for autovacuum_vacuum_cost_delay parameter.
-
autovacuum_vacuum_cost_limit Tables and materialized views
autovacuum_vacuum_cost_limit
Per-table value for autovacuum_vacuum_cost_limit parameter.
-
autovacuum_vacuum_insert_scale_factor Tables and materialized views
autovacuum_vacuum_insert_scale_factor
Per-table value for autovacuum_vacuum_insert_scale_factor parameter.
-
autovacuum_vacuum_insert_threshold Tables and materialized views
autovacuum_vacuum_insert_threshold
Per-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_max_threshold Tables and materialized views
autovacuum_vacuum_max_threshold
Per-table value for autovacuum_vacuum_max_threshold parameter.
-
autovacuum_vacuum_scale_factor Tables and materialized views
autovacuum_vacuum_scale_factor
Per-table value for autovacuum_vacuum_scale_factor parameter.
-
autovacuum_vacuum_threshold Tables and materialized views
autovacuum_vacuum_threshold
Per-table value for autovacuum_vacuum_threshold parameter.
-
fillfactor Tables and materialized views
Tables and materialized views fillfactor
The 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 indicated percentage; the remaining space on each page is re…
-
log_autoanalyze_min_duration
Not recorded in the selected version.
-
log_autovacuum_min_duration Tables and materialized views
log_autovacuum_min_duration
Per-table value for log_autovacuum_min_duration parameter.
-
parallel_workers Tables and materialized views
parallel_workers
This 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 workers chosen by the planner or by utility statements that u…
-
toast_tuple_target Tables and materialized views
toast_tuple_target
The 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 the length below once toasting begins. This affects columns…
-
toast_value_type
Not recorded in the selected version.
-
user_catalog_table Tables and materialized views
user_catalog_table
Declare the table as an additional catalog table for purposes of logical replication. See Section 47.6.2 for details. This parameter cannot be set for TOAST tables.
-
vacuum_index_cleanup Tables and materialized views
vacuum_index_cleanup
Forces 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 dynamically, each time VACUUM runs. The dynamic behavior all…
-
vacuum_max_eager_freeze_failure_rate Tables and materialized views
vacuum_max_eager_freeze_failure_rate
Per-table value for vacuum_max_eager_freeze_failure_rate parameter.
-
vacuum_truncate Tables and materialized views
vacuum_truncate
Per-table value for vacuum_truncate parameter. The TRUNCATE parameter of VACUUM , if specified, overrides the value of this option.
-
check_option View options
check_option
This parameter may be either local or cascaded , and is equivalent to specifying WITH [ CASCADED | LOCAL ] CHECK OPTION (see below).
-
security_barrier View options
security_barrier
This should be used if the view is intended to provide row-level security. See Section 39.5 for full details.
-
security_invoker View options
security_invoker
This 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.
RecordedFirst recordedInterface or attribute changeNo longer recorded
Squares indicate presence in sampled builds, not first introduction. Select a square for the same-version definition and sources.
Changes in PostgreSQL 18.6 · Export JSON
Reading this collection
Set object options with CREATE WITH or ALTER SET. Defaults, inheritance and rebuild requirements depend on the object and version. Global configuration defaults are not explicit relation-option defaults.