The pg_visibility module provides a means for examining the visibility map (VM) and page-level visibility information. It also provides functions

The GIN interface has a high level of abstraction, requiring the access method implementer only to implement the semantics of the data type

The pg_buffercache module provides a means for examining what's happening in the shared buffer cache in real time. The

This section covers implementation details and other tricks that are useful for implementers of SP-GiST operator classes to know.

The earthdistance module provides two different approaches to calculating great circle distances on the surface of the Earth. The one described

Among all relational operators the most difficult one to process and optimize is the join. The number of possible query plans grows exponentially with

NameCREATE TABLE AS -- define a new table from the results of a query Synopsis

NameROLLBACK TO SAVEPOINT -- roll back to a savepoint Synopsis

bloom provides an index access method based on Bloom filters

PostgreSQL implements table inheritance, which can be a useful tool for database designers. (SQL:1999 and later define a type inheritance feature