GIN assumes that indexable operators are strict. This means that extractValue will not be called at all on

The core PostgreSQL distribution includes the BRIN operator classes shown in Table 64-1.

SP-GiST offers an interface with a high level of abstraction, requiring the access method developer to implement only methods specific to

GiST stands for Generalized Search Tree. It is a balanced, tree-structured access method, that acts as a base template in which to implement

PostgreSQL supports a powerful rule system for the specification of views and ambiguous

This section provides an overview of TOAST (The Oversized-Attribute Storage Technique).

SP-GiST is an abbreviation for space-partitioned GiST. SP-GiST supports

Create vs. insert Insertion into a GIN index can be slow due to the likelihood of many keys

Each heap and index relation, except for hash indexes, has a Free Space Map (FSM) to keep track of available space in the relation. It's stored alongside the main relation

Internally, a GIN index contains a B-tree index constructed over keys, where each key is an element of one or more indexed items (a member