From: Mark Kirkwood <markir@paradise.net.nz>
To: Cosimo Streppone <cosimo@streppone.it>
Cc: Martin Fandel <martin.fandel@alphyra-evs.de>
Cc: Postgresql Performance list <pgsql-performance@postgresql.org>
Subject: Re: postgresql-8.0.1 performance tuning
Date: Wed, 01 Jun 2005 18:33:22 +1200
Message-ID: <429D56B2.9070302@paradise.net.nz> (raw)
In-Reply-To: <429D47FD.7090501@streppone.it>
References: <1117201312.7060.6.camel@fandelm.ecommit.de>
<429D47FD.7090501@streppone.it>
Cosimo Streppone wrote:
> ######### Config ############
>> /etc/sysctl.conf:
>> kernel.shmall = 786432000
>> kernel.shmmax = 786432000
>
>
> I think you have a problem here.
> kernel.shmmax should *not* be set to an amount of RAM, but
> to maximum number of shared memory pages, which on a typical linux system
> is 4kb. Google around:
>
>
>
This is somewhat confusing :
kernel.shmmax is in bytes (max single segment size)
kernel.shmall is in (4k) pages (max system wide allocated segment pages)
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, cosimo@streppone.it, martin.fandel@alphyra-evs.de
Subject: Re: postgresql-8.0.1 performance tuning
In-Reply-To: <429D56B2.9070302@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