PREPARE TRANSACTION
  • References/Database/PostgreSQL/Commands

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

2025-01-10 15:47:30
Log File Maintenance
  • References/Database/PostgreSQL/Maintenance

It is a good idea to save the database server's log output somewhere, rather than just discarding it via /dev/null. The log output is invaluable

2025-01-10 15:47:30
Error Message Style Guide
  • References/Database/PostgreSQL/PostgreSQL Coding Conventions

This style guide is offered in the hope of maintaining a consistent, user-friendly style throughout all the messages generated by PostgreSQL

2025-01-10 15:47:30
Internals: Planner/Optimizer
  • References/Database/PostgreSQL/Internals

The task of the planner/optimizer is to create an optimal execution plan. A given SQL query (and hence, a query tree) can be actually executed in a

2025-01-10 15:47:30
Pattern Matching
  • References/Database/PostgreSQL/Functions and Operators

There are three separate approaches to pattern matching provided by PostgreSQL: the traditional SQL

2025-01-10 15:47:30
Asynchronous Commit
  • References/Database/PostgreSQL/Write-Ahead Log

Asynchronous commit is an option that allows transactions to complete more quickly, at the cost that the most recent transactions may be lost if the

2025-01-10 15:47:30
Secure TCP/IP Connections with SSH Tunnels
  • References/Database/PostgreSQL/Server Setup and Operation

It is possible to use SSH to encrypt the network connection between clients and a PostgreSQL server. Done

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

NameDROP DOMAIN -- remove a domain Synopsis

2025-01-10 15:47:30
Internals//SP-GiST Indexes: Built-in Operator Classes
  • References/Database/PostgreSQL/Internals/SP-GiST Indexes

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

2025-01-10 15:47:30
Internals//Index Access Method: Index Locking Considerations
  • References/Database/PostgreSQL/Internals/Index Access Method

Index access methods must handle concurrent updates of the index by multiple processes. The core PostgreSQL system obtains

2025-01-10 15:47:30