Acronyms
  • References/Database/PostgreSQL/Appendixes/Appendixes

This is a list of acronyms commonly used in the PostgreSQL documentation and in discussions about PostgreSQL

2025-01-10 15:47:30
Internals//BRIN Indexes: Extensibility
  • References/Database/PostgreSQL/Internals/BRIN Indexes

The BRIN 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//GiST Indexes: Built-in Operator Classes
  • References/Database/PostgreSQL/Internals/GiST Indexes

The core PostgreSQL distribution includes the GiST operator classes shown in Table 61-1. (Some of the optional

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

The PostgreSQL source distribution includes several examples of index operator classes for SP-GiST, as described

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

The catalog pg_type stores information about data types. Base types and enum types (scalar types) are created with

2025-01-10 15:47:30
Continuous Archiving and Point-in-Time Recovery (PITR)
  • References/Database/PostgreSQL/Backup and Restore

At all times, PostgreSQL maintains a write ahead log (WAL) in the pg_xlog/ subdirectory

2025-01-10 15:47:30
Role Attributes
  • References/Database/PostgreSQL/Database Roles

A database role can have a number of attributes that define its privileges and interact with the client authentication system.

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

This section describes functions for operating on sequence objects, also called sequence generators or just sequences. Sequence objects are special

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

NameCREATE INDEX -- define a new index Synopsis

2025-01-10 15:47:30
Internals//Physical Storage: Database File Layout
  • References/Database/PostgreSQL/Internals/Physical Storage

This section describes the storage format at the level of files and directories. Traditionally, the configuration and data files used by a database

2025-01-10 15:47:30