Re: postgresql-8.0.1 performance tuning

From: Mark Kirkwood <markir(at)paradise(dot)net(dot)nz>
To: Cosimo Streppone <cosimo(at)streppone(dot)it>
Cc: Martin Fandel <martin(dot)fandel(at)alphyra-evs(dot)de>, Postgresql Performance list <pgsql-performance(at)postgresql(dot)org>
Subject: Re: postgresql-8.0.1 performance tuning
Date: 2005-06-01 06:33:22
Message-ID: 429D56B2.9070302@paradise.net.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Cosimo Streppone 2005-06-01 06:44:18 Re: postgresql-8.0.1 performance tuning
Previous Message Tobias Brox 2005-06-01 05:42:51 Re: Index on a NULL-value