Clean up postgresql.conf
От | Bruce Momjian |
---|---|
Тема | Clean up postgresql.conf |
Дата | |
Msg-id | 200701201706.l0KH63p22152@momjian.us обсуждение исходный текст |
Список | 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 по дате отправления: