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.
>
>
>