Re: [PERFORM] Clarification on some settings

[Mark Kirkwood]

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.


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
   (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])