From: Mark Kirkwood <markir@paradise.net.nz>
To: Shridhar Daithankar <shridhar@frodo.hserus.net>
Cc: Doug Y <dylists@ptd.net>
Cc: psql-performance@postgresql.org
Subject: Re: Clarification on some settings
Date: Thu, 13 May 2004 19:31:29 +1200
Message-ID: <40A32451.4010801@paradise.net.nz> (raw)
In-Reply-To: <40A1E83E.2000402@frodo.hserus.net>
References: <6.0.1.1.2.20040511163104.01e9cbb0@mail.traderonline.com>
<40A1E83E.2000402@frodo.hserus.net>
Note that effective_cache_size is merely a hint to that planner to say
"I have this much os buffer cache to use" - it is not actually allocated.
It is shared_buffers that will hurt you if it is too high (10000 - 25000
is the usual sweet spot).
best wishes
Mark
Shridhar Daithankar wrote:
>
>>
>> Increasing the effective cache and sort mem didn't seem to make much
>> of a difference. I'm guessing the eff cache was probably raised a bit
>> too much, and shared_buffers is way to high.
>
>
> I agree. For shared buffers start with 5000 and increase in batches on
> 1000. Or set it to a high value and check with ipcs for maximum shared
> memory usage. If share memory usage peaks at 100MB, you don't need
> more than say 120MB of buffers.
>
>
>
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, shridhar@frodo.hserus.net, dylists@ptd.net, psql-performance@postgresql.org
Subject: Re: Clarification on some settings
In-Reply-To: <40A32451.4010801@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