max_prepared_transactions
A server parameter determining the maximum number of simultaneous prepared transactions
max_prepared_transactions is a configuration parameter determining the maximum number of prepared transactions which can exist simultaneously.
max_prepared_transactions was added in PostgreSQL 8.1.
Default value
The 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 configuration parameters recorded in pg_control.
Change history
- PostgreSQL 8.4
- default value changed from
5to0(commit 8d4f2ecd)
- default value changed from
- PostgreSQL 8.1
- added (commit d0a89683)
References
- PostgreSQL documentation: max_prepared_transactions