Wiki / Storage Parameters / BRIN indexes
autosummarize
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 .
Reading PostgreSQL 18.6.
Description
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 .
- Applies to
- BRIN indexes
- Value type
- boolean
- Default
- off
Usage
WITH (autosummarize = value)Index access method
This entry applies to BRIN indexes. Set it with CREATE INDEX WITH or ALTER INDEX SET. Read defaults and behavior for this specific access method.
Related entries
Documentation and source
Source build
- Version
- 18.6
- Build
- Local English manual 18.6
- Source fingerprint
eb6c2292fdf28e1b4635ab478eec3919411cdf4a6c07553387870e26201f3744
Compare versions
PostgreSQL 11 → 12: changed.
--- PostgreSQL 11
+++ PostgreSQL 12
@@ -7,6 +7,10 @@
{
"label": "Value type",
"value": "boolean"
+ },
+ {
+ "label": "Default",
+ "value": "off"
}
],
"signature": "WITH (autosummarize = value)",Compares recorded interfaces and attributes. Source fingerprints and build metadata are excluded; an absent sample is not proof of the introduction or removal release.
Related entries
pages_per_rangepages_per_range
Export JSON · Back to Storage Parameters · Recorded in PostgreSQL 10 through 20; the first sample is not necessarily its introduction.