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   [EMAIL PROTECTED]
  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);
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org

Reply via email to