The attached, applied paqtch modifies max_fsm_pages in
postgresql.conf.sample to show a typical value, rather than a value too
high.
--
Bruce Momjian bruce@momjian.us
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
Index: backend/utils/misc/postgresql.conf.sample
===================================================================
RCS file: /cvsroot/pgsql/src/backend/utils/misc/postgresql.conf.sample,v
retrieving revision 1.202
diff -c -r1.202 postgresql.conf.sample
*** backend/utils/misc/postgresql.conf.sample 16 Jan 2007 18:26:02 -0000 1.202
--- backend/utils/misc/postgresql.conf.sample 20 Jan 2007 17:03:03 -0000
***************
*** 111,117 ****
# - Free Space Map -
! #max_fsm_pages = 1638400 # min max_fsm_relations*16, 6 bytes each
# (change requires restart)
#max_fsm_relations = 1000 # min 100, ~70 bytes each
# (change requires restart)
--- 111,117 ----
# - Free Space Map -
! #max_fsm_pages = 204800 # min max_fsm_relations*16, 6 bytes each
# (change requires restart)
#max_fsm_relations = 1000 # min 100, ~70 bytes each
# (change requires restart)
Index: bin/initdb/initdb.c
===================================================================
RCS file: /cvsroot/pgsql/src/bin/initdb/initdb.c,v
retrieving revision 1.128
diff -c -r1.128 initdb.c
*** bin/initdb/initdb.c 6 Jan 2007 19:40:00 -0000 1.128
--- bin/initdb/initdb.c 20 Jan 2007 17:03:04 -0000
***************
*** 1251,1257 ****
conflines = replace_token(conflines, "#shared_buffers = 32MB", repltok);
snprintf(repltok, sizeof(repltok), "max_fsm_pages = %d", n_fsm_pages);
! conflines = replace_token(conflines, "#max_fsm_pages = 1638400", repltok);
#if DEF_PGPORT != 5432
snprintf(repltok, sizeof(repltok), "#port = %d", DEF_PGPORT);
--- 1251,1257 ----
conflines = replace_token(conflines, "#shared_buffers = 32MB", repltok);
snprintf(repltok, sizeof(repltok), "max_fsm_pages = %d", n_fsm_pages);
! conflines = replace_token(conflines, "#max_fsm_pages = 204800", repltok);
#if DEF_PGPORT != 5432
snprintf(repltok, sizeof(repltok), "#port = %d", DEF_PGPORT);