pgsql-server/ oc/src/sgml/runtime.sgml rc/back ...
pgsql-server/ oc/src/sgml/runtime.sgml rc/back ...
От:
tgl@svr1.postgresql.org (Tom Lane)
Дата:
CVSROOT: /cvsroot Module name: pgsql-server Changes by: tgl@svr1.postgresql.org 03/07/14 17:00:24 Modified files: doc/src/sgml : runtime.sgml src/backend/port: sysv_shmem.c src/backend/utils/init: postinit.c src/backend/utils/misc: postgresql.conf.sample src/bin/initdb : initdb.sh Log message: The default values for shared_buffers and max_connections are now 1000 and 100 respectively, if the platform will allow it. initdb selects values that are not too large to allow the postmaster to start, and places these values in the installed postgresql.conf file. This allows us to continue to start up out-of-the-box on platforms with small SHMMAX, while having somewhat-realistic default settings on platforms with reasonable SHMMAX. Per recent pghackers discussion.
Re: pgsql-server/ oc/src/sgml/runtime.sgml rc/back ...
От:
Bruce Momjian <pgman@candle.pha.pa.us>
Дата:
Nice work! From initdb.sh: for nbuffers in 1000 900 800 700 600 500 400 300 200 100 50 do TEST_OPT="$PGSQL_OPT -c shared_buffers=$nbuffers -c max_connections=5" if "$PGPATH"/postgres -boot -x0 $TEST_OPT template1 /dev/null 2>&1 then break fi done --------------------------------------------------------------------------- Tom Lane wrote: > CVSROOT: /cvsroot > Module name: pgsql-server > Changes by: tgl@svr1.postgresql.org 03/07/14 17:00:24 > > Modified files: > doc/src/sgml : runtime.sgml > src/backend/port: sysv_shmem.c > src/backend/utils/init: postinit.c > src/backend/utils/misc: postgresql.conf.sample > src/bin/initdb : initdb.sh > > Log message: > The default values for shared_buffers and max_connections are now 1000 > and 100 respectively, if the platform will allow it. initdb selects > values that are not too large to allow the postmaster to start, and > places these values in the installed postgresql.conf file. This allows > us to continue to start up out-of-the-box on platforms with small SHMMAX, > while having somewhat-realistic default settings on platforms with > reasonable SHMMAX. Per recent pghackers discussion. > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org > -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073