Clean up postgresql.conf - Mailing list pgsql-patches

From Bruce Momjian
Subject Clean up postgresql.conf
Date
Msg-id 200701201706.l0KH63p22152@momjian.us
Whole thread Raw
List pgsql-patches
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);

pgsql-patches by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [PATCHES] psql \lo_* quiet mode patch
Next
From: Neil Conway
Date:
Subject: Re: largeobject regression tests - updated patch