The core PostgreSQL distribution includes the SP-GiST operator classes shown in Table 62-1.

The task of the planner/optimizer is to create an optimal execution plan. A given SQL query (and hence, a query tree) can be actually executed in a

In an index scan, the index access method is responsible for regurgitating the TIDs of all the tuples it has been told about that match the scan keys

Index access methods must handle concurrent updates of the index by multiple processes. The core PostgreSQL system obtains

The GEQO module approaches the query optimization problem as though it were the well-known traveling salesman problem (

BRIN stands for Block Range Index. BRIN is designed for handling very large tables in which certain columns

PostgreSQL enforces SQL uniqueness constraints using unique indexes, which are indexes that disallow multiple entries

The PostgreSQL source distribution includes several examples of index methods implemented using GiST. The

Each unlogged table, and each index on an unlogged table, has an initialization fork. The initialization fork is an empty table or index of the appropriate type. When an unlogged

Traditionally, implementing a new index access method meant a lot of difficult work. It was necessary to understand the inner workings of the database, such as the lock manager