Server Configuration: Preset Options
  • References/Database/PostgreSQL/Server Configuration

The following "parameters" are read-only, and are determined when PostgreSQL is compiled or when it is installed

2025-01-10 15:47:30
pgstattuple
  • References/Database/PostgreSQL/Appendixes/Additional Supplied Modules

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

2025-01-10 15:47:30
sslinfo
  • References/Database/PostgreSQL/Appendixes/Additional Supplied Modules

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

2025-01-10 15:47:30
How Parallel Query Works
  • References/Database/PostgreSQL/Parallel Query

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

2025-01-10 15:47:30
uuid-ossp
  • References/Database/PostgreSQL/Appendixes/Additional Supplied Modules

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

2025-01-10 15:47:30
Internals//GIN Indexes: Limitations
  • References/Database/PostgreSQL/Internals/GIN Indexes

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

2025-01-10 15:47:30
CREATE TABLESPACE
  • References/Database/PostgreSQL/Commands

NameCREATE TABLESPACE -- define a new tablespace Synopsis

2025-01-10 15:47:30
Caveats
  • References/Database/PostgreSQL/Concurrency Control

Some DDL commands, currently only TRUNCATE and the table-rewriting forms of

2025-01-10 15:47:30
When Can Parallel Query Be Used?
  • References/Database/PostgreSQL/Parallel Query

There are several settings which can cause the query planner not to generate a parallel query plan under any circumstances. In order for any parallel query plans whatsoever

2025-01-10 15:47:30
CREATE DOMAIN
  • References/Database/PostgreSQL/Commands

NameCREATE DOMAIN -- define a new domain Synopsis

2025-01-10 15:47:30