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
FAQ