From 9a39ba4b0fe6dc6b3744b31bc5115837b88677ae Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Fri, 27 Dec 2002 14:06:34 +0000 Subject: Trivial patch to increase max_fsm_pages as per earlier discussion. Philip Warner --- src/backend/utils/misc/guc.c | 4 ++-- src/backend/utils/misc/postgresql.conf.sample | 2 +- 2 files changed, 3 insertions(+), 3 deletions(-) (limited to 'src') diff --git a/src/backend/utils/misc/guc.c b/src/backend/utils/misc/guc.c index 02c78e0de01..bd63313cd23 100644 --- a/src/backend/utils/misc/guc.c +++ b/src/backend/utils/misc/guc.c @@ -5,7 +5,7 @@ * command, configuration file, and command line options. * See src/backend/utils/misc/README for more information. * - * $Header: /cvsroot/pgsql/src/backend/utils/misc/guc.c,v 1.108 2002/12/02 05:20:47 tgl Exp $ + * $Header: /cvsroot/pgsql/src/backend/utils/misc/guc.c,v 1.109 2002/12/27 14:06:34 momjian Exp $ * * Copyright 2000 by PostgreSQL Global Development Group * Written by Peter Eisentraut . @@ -632,7 +632,7 @@ static struct config_int { {"max_fsm_relations", PGC_POSTMASTER}, &MaxFSMRelations, - 100, 10, INT_MAX, NULL, NULL + 1000, 10, INT_MAX, NULL, NULL }, { {"max_fsm_pages", PGC_POSTMASTER}, &MaxFSMPages, diff --git a/src/backend/utils/misc/postgresql.conf.sample b/src/backend/utils/misc/postgresql.conf.sample index 1c4595a66bf..ef91d248283 100644 --- a/src/backend/utils/misc/postgresql.conf.sample +++ b/src/backend/utils/misc/postgresql.conf.sample @@ -48,7 +48,7 @@ # Shared Memory Size # #shared_buffers = 64 # 2*max_connections, min 16, typically 8KB each -#max_fsm_relations = 100 # min 10, fsm is free space map, ~40 bytes +#max_fsm_relations = 1000 # min 10, fsm is free space map, ~40 bytes #max_fsm_pages = 10000 # min 1000, fsm is free space map, ~6 bytes #max_locks_per_transaction = 64 # min 10 #wal_buffers = 8 # min 4, typically 8KB each -- cgit v1.2.3