Durability is a database feature that guarantees the recording of committed transactions even if the server crashes or loses power. However, durability adds significant database

The pg_lsn data type can be used to store LSN (Log Sequence Number) data which is a pointer to a location in the XLOG. This type is a representation

19.8.1. Where To Log log_destination (string)

PostgreSQL offers encryption at several levels, and provides flexibility in protecting data from disclosure due to database server theft, unscrupulous

The catalog pg_database stores information about the available databases. Databases are created with the

NameVALUES -- compute a set of rows Synopsis

This module implements a data type cube for representing multidimensional cubes. F

A partial index is an index built over a subset of a table; the subset is defined by a conditional expression (called the predicate

This section describes functions and operators for examining and manipulating string values. Strings in this context include values of the types character

PostgreSQL databases require periodic maintenance known as vacuuming. For many installations, it is sufficient to