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
