max_prepared_transactions

A GUC determining the maximum number of prepared transactions which can exist simultaneously

max_prepared_transactions is a GUC determining the maximum number of prepared transactions which can exist simultaneously.

max_prepared_transactions was added in PostgreSQL 8.1 (commit d0a89683).

Default

Default value for max_prepared_transactions is 0.

Usage

On a standby, max_prepared_transactions must be set to the same or higher value as on the primary.

The documentation recommends setting max_prepared_transactions to be at least as large as max_connections, though this is not mandatory.

The current value of max_prepared_transactions is one of the GUC configuration parameters recorded in pg_control.

Categories

Critical standby configuration item, GUC configuration item, Memory, Transactions

See also

PREPARE TRANSACTION, pg_prepared_xacts, max_connections