diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2005-08-30 01:37:38 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2005-08-30 01:37:38 +0000 |
| commit | cc367951a924855b910d0007934e0ef0cc27940a (patch) | |
| tree | 7bc9cf8b620fccc458a904dfe3095c52649bb186 | |
| parent | 13065c7174ea6e60bbf619f21b0fa382718acaf0 (diff) | |
| download | postgresql-cc367951a924855b910d0007934e0ef0cc27940a.tar.gz postgresql-cc367951a924855b910d0007934e0ef0cc27940a.zip | |
Mention max_prepared_transactions in PREPARE TRANSACTION reference page,
per Bruce's suggestion.
| -rw-r--r-- | doc/src/sgml/ref/prepare_transaction.sgml | 12 |
1 files changed, 11 insertions, 1 deletions
diff --git a/doc/src/sgml/ref/prepare_transaction.sgml b/doc/src/sgml/ref/prepare_transaction.sgml index 277b9c53f19..6230f043825 100644 --- a/doc/src/sgml/ref/prepare_transaction.sgml +++ b/doc/src/sgml/ref/prepare_transaction.sgml @@ -1,5 +1,5 @@ <!-- -$PostgreSQL: pgsql/doc/src/sgml/ref/prepare_transaction.sgml,v 1.2 2005/08/01 19:38:03 momjian Exp $ +$PostgreSQL: pgsql/doc/src/sgml/ref/prepare_transaction.sgml,v 1.3 2005/08/30 01:37:38 tgl Exp $ PostgreSQL documentation --> @@ -117,6 +117,16 @@ PREPARE TRANSACTION <replaceable class="PARAMETER">transaction_id</replaceable> committed or rolled back as soon as an external transaction manager has verified that other databases are also prepared to commit. </para> + + <para> + If you make any serious use of prepared transactions, you will probably + want to increase the value of <xref + linkend="guc-max-prepared-transactions">, as the default setting is + quite small (to avoid wasting resources for those who don't use it). + It is recommendable to make it at least equal to + <xref linkend="guc-max-connections">, so that every session can have + a prepared transaction pending. + </para> </refsect1> <refsect1 id="sql-prepare-transaction-examples"> |