When an object is created, it is assigned an owner. The owner is normally the role that executed the creation statement. For most kinds of objects, the initial state is that

Namepg_dumpall -- extract a PostgreSQL database cluster into a script file

The pgstattuple module provides various functions to obtain tuple-level statistics. F

Namevacuumdb -- garbage-collect and analyze a PostgreSQL database

The sslinfo module provides information about the SSL certificate that the current client provided when connecting to

When the optimizer determines that parallel query is the fastest execution strategy for a particular query, it will create a query plan which includes a Gather

Though PostgreSQL provides nonblocking read/write access to table data, nonblocking read/write access is not currently offered for every index

The uuid-ossp module provides functions to generate universally unique identifiers (UUIDs) using one of several standard algorithms. There are

GIN assumes that indexable operators are strict. This means that extractValue will not be called at all on

Hot Standby is the term used to describe the ability to connect to the server and run read-only queries while the server is in archive recovery or standby mode. This is useful