NameCLUSTER -- cluster a table according to an index Synopsis

The pg_prewarm module provides a convenient way to load relation data into either the operating system buffer cache or the

The catalog pg_tablespace stores information about the available tablespaces. Tables can be placed in particular tablespaces to aid administration

A composite type represents the structure of a row or record; it is essentially just a list of field names and their data types.

PostgreSQL provides several index types: B-tree, Hash, GiST, SP-GiST, GIN and BRIN. Each index type uses a different algorithm that is best

NameCREATE TEXT SEARCH CONFIGURATION -- define a new text search configuration

Numeric types consist of two-, four-, and eight-byte integers, four- and eight-byte floating-point numbers, and selectable-precision decimals. Table 8-2 lists the available

PostgreSQL offers data types to store IPv4, IPv6, and MAC addresses, as shown in Table 8-21. It is better to use these types instead of plain

The catalog pg_policy stores row level security policies for tables. A policy includes the kind of command that it applies to (possibly all

The catalog pg_attrdef stores column default values. The main information about columns is stored in pg_attribute