From 037709e0b3da1f7ac3d794c60216365cf3e23de1 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Mon, 29 Aug 2005 21:38:18 +0000 Subject: Reduce default value of max_prepared_transactions from 50 to 5. This saves nearly 700kB in the default shared memory segment size, which seems worthwhile, and it is a feature that many users won't use anyway. Per Heikki's argument, there is no point in a compromise value --- those who are using 2PC at all will probably want it at least equal to max_connections. But we can't set it to zero by default without breaking the prepared_xacts regression test. --- doc/src/sgml/runtime.sgml | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'doc/src') diff --git a/doc/src/sgml/runtime.sgml b/doc/src/sgml/runtime.sgml index 320f1bfb8e8..e346ece23ca 100644 --- a/doc/src/sgml/runtime.sgml +++ b/doc/src/sgml/runtime.sgml @@ -1,5 +1,5 @@ @@ -1179,7 +1179,7 @@ SET ENABLE_SEQSCAN TO OFF; endterm="sql-prepare-transaction-title">). Setting this parameter to zero disables the prepared-transaction feature. - The default is 50. + The default is 5. This option can only be set at server start. -- cgit v1.2.3