Documentation / Storage Parameters / GIN indexes
gin_pending_list_limit
gin_pending_list_limit
Overrides the global setting of gin_pending_list_limit for this index. This value is specified in kilobytes.
Reading PostgreSQL 18.6.
Description
Overrides the global setting of gin_pending_list_limit for this index. This value is specified in kilobytes.
- Applies to
- GIN indexes
- Value type
- integer
Usage
WITH (gin_pending_list_limit = value)Index access method
This entry applies to GIN indexes. Set it with CREATE INDEX WITH or ALTER INDEX SET. Read defaults and behavior for this specific access method.
Related global parameter: gin_pending_list_limit
The following same-version GUC definition explains its purpose and units. Global defaults and activation rules describe the GUC; the relation-option override rules remain those above.
Sets the maximum size of a GIN index's pending list, which is used when fastupdate is enabled. If the list grows larger than this maximum size, it is cleaned up by moving the entries in it to the index's main GIN data structure in bulk. If this value is specified without units, it is taken as kilobytes. The default is four megabytes ( 4MB ). This setting can be overridden for individual GIN indexes by changing index storage parameters. See Section 65.4.4.1 and Section 65.4.5 for more information.
Related entries
Documentation and source
Source build
- Version
- 18.6
- Build
- Local English manual 18.6
- Source fingerprint
eb6c2292fdf28e1b4635ab478eec3919411cdf4a6c07553387870e26201f3744
Related entries
fastupdatefastupdate
Back to Storage Parameters · Recorded in PostgreSQL 10 through 20; the first sample is not necessarily its introduction.