The planner classifies operations involved in a query as either parallel safe, parallel restricted, or parallel

The view pg_locks provides access to information about the locks held by active processes within the database server. See Chapter 13 for more

NameCREATE MATERIALIZED VIEW -- define a new materialized view Synopsis

NameDROP EVENT TRIGGER -- remove an event trigger Synopsis

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

The tablefunc module includes various functions that return tables (that is, multiple rows). These functions are useful both in their own right

Before you can do anything, you must initialize a database storage area on disk. We call this a database cluster. (The SQL

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

PostgreSQL allows functions that have named parameters to be called using either positional or named

19.7.1. Planner Method Configuration These configuration parameters provide a crude method of influencing the query plans chosen