From: | dx k9 <bitsandbytes88(at)hotmail(dot)com> |
---|---|
To: | posgres support <pgsql-admin(at)postgresql(dot)org> |
Subject: | effective_cache_size v824 |
Date: | 2007-11-13 19:54:10 |
Message-ID: | BAY116-W40AD153AA1BBF24778CC10D1800@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi,
I'm playing around with the effective cache size setting today. Someone recommended the formula
((buffers + cached ) / 8 ) during heavy querying to optimize the 'Postgresql.conf' setting.
I have 4 separate physical servers and I have all of them set to 512 MB, even though the results of the formula show.
Server 1 1 GB
Server 2 1 GB
Server 3 2 GB
Server 4 2 GB
These results indicate that I should raise my effective_cache_size on all the servers. My shared buffers settings are all 256 MB.
Does it matter that I have 2 instances running on each of these servers? IOW, should I divide the results in half, one for each instance and go with this as the recommended effective_cache_size setting instead?
Server 1 512 MB
Server 2 512 MB
Server 3 1 GB
Server 4 1 GB
Thanks for any insight,
~DjK
_________________________________________________________________
Help yourself to FREE treats served up daily at the Messenger Café. Stop by today.
http://www.cafemessenger.com/info/info_sweetstuff2.html?ocid=TXT_TAGLM_OctWLtagline
From | Date | Subject | |
---|---|---|---|
Next Message | Laszlo Nagy | 2007-11-13 20:00:02 | SHMMAX problem - how much is needed? |
Previous Message | Mike Blackwell | 2007-11-13 19:22:33 | Escape string tracing |