BRIN stands for Block Range Index. BRIN is designed for handling very large tables in which certain columns

NamePREPARE TRANSACTION -- prepare the current transaction for two-phase commit

In an index scan, the index access method is responsible for regurgitating the TIDs of all the tuples it has been told about that match the scan keys

NameSET ROLE -- set the current user identifier of the current session Synopsis

Namepg_test_fsync -- determine fastest wal_sync_method for PostgreSQL

In order to create a database, the PostgreSQL server must be up and running (see

PostgreSQL provides a rich set of tools for developers to manage concurrent access to data. Internally, data consistency is maintained by using

The core PostgreSQL distribution includes the SP-GiST operator classes shown in Table 62-1.

NameSELECT, TABLE, WITH -- retrieve rows from a table or view Synopsis

The catalog pg_authid contains information about database authorization identifiers (roles). A role subsumes the concepts of