↑↓ select ↵ open ⌫ change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Functions / System Administration Functions

gin_clean_pending_list

Read the PG 18 manual

Cleans up the “pending” list of the specified GIN index by moving entries in it, in bulk, to the main GIN data structure.

Reading PG 18current·documented in 12 of 27 versions, 9.6 to 20

Signatures & examples

gin_clean_pending_list ( index regclass ) → bigint
Cleans up the “pending” list of the specified GIN index by moving entries in it, in bulk, to the main GIN data structure. Returns the number of pages removed from the pending list. If the argument is a GIN index built with the fastupdate option disabled, no cleanup happens and the result is zero, because the index doesn't have a pending list. See Section 65.4.4.1 and Section 65.4.5 for details about the pending list and fastupdate option.
Version history 6
  1. 17 → 18 changed
  2. 16 → 17 changed
  3. 14 → 15 changed
  4. 13 → 14 changed
  5. 12 → 13 changed
  6. 9.5 → 9.6 added

Definition snapshot: b7bd9cda · English manual source