String Functions and Operators
  • References/Database/PostgreSQL/Functions/String

This section describes functions and operators for examining and manipulating string values. Strings in this context include values of the types character

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

Create vs. insert Insertion into a GIN index can be slow due to the likelihood of many keys

2025-01-10 15:47:30
Catalogs: pg_seclabel
  • References/Database/PostgreSQL/Internals: Catalogs

The catalog pg_seclabel stores security labels on database objects. Security labels can be manipulated with the

2025-01-10 15:47:30
Server Configuration: Error Reporting and Logging
  • References/Database/PostgreSQL/Server Configuration

19.8.1. Where To Log log_destination (string)

2025-01-10 15:47:30
Catalogs: pg_extension
  • References/Database/PostgreSQL/Internals: Catalogs

The catalog pg_extension stores information about the installed extensions. See Section 36.15 for details about extensions.

2025-01-10 15:47:30
RELEASE SAVEPOINT
  • References/Database/PostgreSQL/Commands

NameRELEASE SAVEPOINT -- destroy a previously defined savepoint Synopsis

2025-01-10 15:47:30
Performance Tips: Statistics Used by the Planner
  • References/Database/PostgreSQL/Performance Tips

As we saw in the previous section, the query planner needs to estimate the number of rows retrieved by a query in order to make good choices of query plans. This section provides

2025-01-10 15:47:30
Server Configuration: Lock Management
  • References/Database/PostgreSQL/Server Configuration

deadlock_timeout (integer) This is the amount of time, in milliseconds

2025-01-10 15:47:30
pg_isready
  • References/Database/PostgreSQL/Applications

Namepg_isready -- check the connection status of a PostgreSQL server

2025-01-10 15:47:30
Composite Types
  • References/Database/PostgreSQL/Data Types

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

2025-01-10 15:47:30