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
5
to0
(commit 8d4f2ecd)
- default value changed from
- PostgreSQL 8.1
- added (commit d0a89683)
References
- PostgreSQL documentation: max_prepared_transactions