From: Mark Kirkwood <markir@paradise.net.nz>
To: Martin Fandel <martin.fandel@alphyra-evs.de>
Cc: pgsql-performance@postgresql.org
Subject: Re: SHMMAX / SHMALL Was (Re: postgresql-8.0.1 performance
Date: Fri, 03 Jun 2005 21:10:24 +1200
Message-ID: <42A01E80.2030507@paradise.net.nz> (raw)
In-Reply-To: <1117788544.4380.79.camel@fandelm.ecommit.de>
References: <1117201312.7060.6.camel@fandelm.ecommit.de>
<1117788544.4380.79.camel@fandelm.ecommit.de>
Martin Fandel wrote:
> Aah ok :)
>
> I've set my values now as follow (2GB RAM):
>
> SHMMAX=`cat /proc/meminfo | grep MemTotal | cut -d: -f 2 | awk '{print
> $1*1024/3}'`
> echo kernel.shmmax=${SHMMAX} >> /etc/sysctl.conf
> SHMALL=`expr ${SHMALL} / 4096 \* \( 4096 / 16 \)`
> echo kernel.shmall=${SHMALL} >> /etc/sysctl.conf
>
> sysctl.conf:
> kernel.shmmax=708329472
> kernel.shmall=44270592
>
> postgresql.conf:
> max_connections=500
> shared_buffers=40000 # ~312MB, min. 1000, max ~ 83000
>
Hmmm - shmall set to 168G... err why? Apologies for nit picking a little
- but shmall seems unreasonably high. I can't see much reason for
setting it bigger than (physical RAM in bytes)/4096 myself. So in your
case this is 2*(1024*1024*1024)/4096 = 524288
Cheers
Mark
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: markir@paradise.net.nz, martin.fandel@alphyra-evs.de
Subject: Re: SHMMAX / SHMALL Was (Re: postgresql-8.0.1 performance
In-Reply-To: <42A01E80.2030507@paradise.net.nz>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox