Обсуждение: 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
Дата:
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@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