Internals//GIN Indexes: Built-in Operator Classes
  • References/Database/PostgreSQL/Internals/GIN Indexes

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

2025-01-10 15:47:30
Managing Kernel Resources
  • References/Database/PostgreSQL/Server Setup and Operation

PostgreSQL can sometimes exhaust various operating system resource limits, especially when multiple copies of the server are running on the

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

NameABORT -- abort the current transaction Synopsis

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

The catalog pg_aggregate stores information about aggregate functions. An aggregate function is a function that operates on a set of values

2025-01-10 15:47:30
Event Trigger Functions
  • References/Database/PostgreSQL/Functions/Event Trigger

PostgreSQL provides these helper functions to retrieve information from event triggers. For more information

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

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

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
UUID Type
  • References/Database/PostgreSQL/Data Types

The data type uuid stores Universally Unique Identifiers (UUID) as defined by RFC 4122, ISO/IEC 9834-8:2005, and related standards. (Some systems

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
ALTER TEXT SEARCH PARSER
  • References/Database/PostgreSQL/Commands

NameALTER TEXT SEARCH PARSER -- change the definition of a text search parser

2025-01-10 15:47:30