Full Text Searching (or just text search) provides the capability to identify natural-language documents that satisfy a

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

An index can be defined on more than one column of a table. For example, if you have a table of this form:

Namepg_basebackup -- take a base backup of a PostgreSQL cluster

Each heap relation has a Visibility Map (VM) to keep track of which pages contain only tuples that are known to be visible to all active transactions; it also keeps track of

It is possible to control the query planner to some extent by using the explicit JOIN syntax. To see why this matters, we first need some background

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

WAL is automatically enabled; no action is required from the administrator except ensuring that the disk-space requirements for the

On most Unix platforms, PostgreSQL modifies its command title as reported by ps, so that individual server processes

The view pg_timezone_abbrevs provides a list of time zone abbreviations that are currently recognized by the datetime input routines. The contents