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 . Turning fastupdate off via ALTER INDEX prevents future insertions from going into the list of pending index entries, but does not in itself flush existing entries. You might want to VACUUM the table or call the gin_clean_pending_list function afterward to ensure the pending list is emptied.
Reading PG 18·Select a recorded version
- Applies to
- GIN indexes
- Value type
- boolean
- Default
- ON
- signature
- WITH (fastupdate = value)
Definition PG 18
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 . Turning fastupdate off via ALTER INDEX prevents future insertions from going into the list of pending index entries, but does not in itself flush existing entries. You might want to VACUUM the table or call the gin_clean_pending_list function afterward to ensure the pending list is emptied.
Compare versions
Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · eb6c2292fdf28e1b4635ab478eec3919411cdf4a6c07553387870e26201f3744
Text language: en · eb6c2292fdf28e1b4635ab478eec3919411cdf4a6c07553387870e26201f3744