Contents
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.
References
- PostgreSQL documentation: max_prepared_transactions