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. --- src/backend/utils/misc/guc.c | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'src/backend/utils/misc/guc.c') diff --git a/src/backend/utils/misc/guc.c b/src/backend/utils/misc/guc.c index 29e0e409307..b9e8ff3122e 100644 --- a/src/backend/utils/misc/guc.c +++ b/src/backend/utils/misc/guc.c @@ -10,7 +10,7 @@ * Written by Peter Eisentraut . * * IDENTIFICATION - * $PostgreSQL: pgsql/src/backend/utils/misc/guc.c,v 1.286 2005/08/22 17:34:59 momjian Exp $ + * $PostgreSQL: pgsql/src/backend/utils/misc/guc.c,v 1.287 2005/08/29 21:38:18 tgl Exp $ * *-------------------------------------------------------------------- */ @@ -1203,7 +1203,7 @@ static struct config_int ConfigureNamesInt[] = NULL }, &max_prepared_xacts, - 50, 0, INT_MAX, NULL, NULL + 5, 0, INT_MAX, NULL, NULL }, #ifdef LOCK_DEBUG -- cgit v1.2.3