Re: pgsql-server/ oc/src/sgml/runtime.sgml rc/back ...

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Tom Lane <tgl(at)svr1(dot)postgresql(dot)org>
Cc: pgsql-committers(at)postgresql(dot)org
Subject: Re: pgsql-server/ oc/src/sgml/runtime.sgml rc/back ...
Date: 2003-07-21 02:47:21
Message-ID: 200307210247.h6L2lLG15645@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers


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 >/dev/null 2>&1
then
break
fi
done

---------------------------------------------------------------------------

Tom Lane wrote:
> CVSROOT: /cvsroot
> Module name: pgsql-server
> Changes by: tgl(at)svr1(dot)postgresql(dot)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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Browse pgsql-committers by date

  From Date Subject
Next Message Bruce Momjian 2003-07-21 04:18:44 pgsql-server/doc FAQ_japanese src/FAQ/FAQ_japa ...
Previous Message Tom Lane 2003-07-21 01:59:14 pgsql-server/src backend/catalog/aclchk.c back ...