From: Richard Huxton <dev@archonet.com>
To: paul@wayr.org
Cc: pgsql-performance@postgresql.org
Subject: Re: dedicated server & postgresql 8.1 conf tunning
Date: Thu, 02 Oct 2008 09:29:19 +0100
Message-ID: <48E4865F.3010807@archonet.com> (raw)
In-Reply-To: <6439bfe8d4afed3a360b906353c7e9e5@localhost>
References: <48E360D0.8080403@archonet.com>
<6439bfe8d4afed3a360b906353c7e9e5@localhost>
paul@wayr.org wrote:
> Thanks,
>
> Unfornatly, i can't update pgsql to 8.3 since it's not in debian stable.
That's why backports.org was invented :-)
Or does can't mean "not allowed to"?
> So i'm going to play with work_mem & shared_buffers.
>
> With big shared_buffers pgsql tells me
> shmget(cle=5432001, taille=11183431680, 03600).
> so i do "echo 13183431680 > /proc/sys/kernel/shmmax" ( 10Go + 2Go just
> in case)
>
> but pgsql tells me again that it there's not enought shm..
> How can i compute the go shmmax for my server ?
I'm not seeing anything terribly wrong there. Are you hitting a limit
with shmall?
Oh - and I'm not sure there's much point in having more shared-buffers
than you have data.
Try much larger work_mem first, I think that's the biggest gain for you.
--
Richard Huxton
Archonet Ltd
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: dev@archonet.com, paul@wayr.org
Subject: Re: dedicated server & postgresql 8.1 conf tunning
In-Reply-To: <48E4865F.3010807@archonet.com>
* 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