Re: Clarification on some settings - Mailing list pgsql-performance

From Mark Kirkwood
Subject Re: Clarification on some settings
Date
Msg-id 40A32451.4010801@paradise.net.nz
Whole thread Raw
In response to Re: Clarification on some settings  (Shridhar Daithankar <shridhar@frodo.hserus.net>)
List pgsql-performance
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.
>
>
>

pgsql-performance by date:

Previous
From: "Fabio Panizzutti"
Date:
Subject: R: Query plan on identical tables differs . Why ?
Next
From: Tom Lane
Date:
Subject: Re: R: Query plan on identical tables differs . Why ?