Internals//GIN Indexes: Extensibility
  • References/Database/PostgreSQL/Internals/GIN Indexes

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

2025-01-10 15:47:30
Internals//SP-GiST Indexes: Implementation
  • References/Database/PostgreSQL/Internals/SP-GiST Indexes

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

2025-01-10 15:47:30
Catalogs: pg_auth_members
  • References/Database/PostgreSQL/Internals: Catalogs

The catalog pg_auth_members shows the membership relations between roles. Any non-circular set of relationships is allowed.

2025-01-10 15:47:30
Reliability
  • References/Database/PostgreSQL/Write-Ahead Log

Reliability is an important property of any serious database system, and PostgreSQL does everything possible to guarantee reliable operation

2025-01-10 15:47:30
Date/Time Functions and Operators
  • References/Database/PostgreSQL/Functions/DateTime

Table 9-30 shows the available functions for date/time value processing, with details appearing in the following subsections. Table 9-29 illustrates the behaviors of the basic

2025-01-10 15:47:30
JSON Types
  • References/Database/PostgreSQL/Data Types

JSON data types are for storing JSON (JavaScript Object Notation) data, as specified in RFC 7159.

2025-01-10 15:47:30
VACUUM
  • References/Database/PostgreSQL/Commands

NameVACUUM -- garbage-collect and optionally analyze a database Synopsis

2025-01-10 15:47:30
pg_visibility
  • References/Database/PostgreSQL/Appendixes/Additional Supplied Modules

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

2025-01-10 15:47:30
Catalogs: pg_range
  • References/Database/PostgreSQL/Internals: Catalogs

The catalog pg_range stores information about range types. This is in addition to the types' entries in

2025-01-10 15:47:30
ABORT
  • References/Database/PostgreSQL/Commands

NameABORT -- abort the current transaction Synopsis

2025-01-10 15:47:30