Jim, list,from your link:ttp://www.varlena.com/GeneralBits/Tidbits/annotated_conf_e.html
I quote:"""As a rule of thumb,
observe shared memory usage of PostgreSQL with
tools like ipcs and determine the setting. Remember that this is
only half the story. You also need to set effective_ca
On Oct 11, 2006, at 03:34 , Jim C. Nasby wrote:
And increase estimated_cache_size to something close
to how much memory you have.
That would be "effective_cache_size".
Alexander.
---(end of broadcast)---
TIP 6: explain analyze is your friend
Please take a look at
http://www.varlena.com/GeneralBits/Tidbits/annotated_conf_e.html first.
In a nutshell, set shared_buffers to between 10% and 25% of your memory
if it's a server. And increase estimated_cache_size to something close
to how much memory you have.
On Tue, Oct 03, 2006 at 07:50:4
