Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-committers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group