Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 2FD812E2D35 for ; Tue, 13 Nov 2007 15:54:21 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 85500-04 for ; Tue, 13 Nov 2007 15:53:59 -0400 (AST) Received: from bay0-omc3-s7.bay0.hotmail.com (bay0-omc3-s7.bay0.hotmail.com [65.54.246.207]) by postgresql.org (Postfix) with ESMTP id B711B2E072B for ; Tue, 13 Nov 2007 15:54:10 -0400 (AST) Received: from BAY116-W40 ([64.4.38.140]) by bay0-omc3-s7.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.3959); Tue, 13 Nov 2007 11:54:10 -0800 Message-ID: Content-Type: multipart/alternative; boundary="_ddd12a70-144d-4ebd-924d-73f8bdff7579_" X-Originating-IP: [204.132.58.73] From: dx k9 To: posgres support Subject: effective_cache_size v824 Date: Tue, 13 Nov 2007 14:54:10 -0500 Importance: Normal MIME-Version: 1.0 X-OriginalArrivalTime: 13 Nov 2007 19:54:10.0601 (UTC) FILETIME=[F54F1190:01C8262E] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.601 tagged_above=0 required=5 tests=AWL=0.599, BAYES_50=0.001, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200711/107 X-Sequence-Number: 27350 --_ddd12a70-144d-4ebd-924d-73f8bdff7579_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, I'm playing around with the effective cache size setting today. Someone re= commended the formula ((buffers + cached ) / 8 ) during heavy querying to optimize the 'Postgresq= l.conf' setting. I have 4 separate physical servers and I have all of them set to 512 MB, ev= en 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 t= he servers. My shared buffers settings are all 256 MB. Does it matter that I have 2 instances running on each of these servers? I= OW, 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=E9. Stop = by today. http://www.cafemessenger.com/info/info_sweetstuff2.html?ocid=3DTXT_TAGLM_Oc= tWLtagline= --_ddd12a70-144d-4ebd-924d-73f8bdff7579_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi,

I'm playing around with the effective cache size setting today.&= nbsp; Someone recommended the formula
((buffers + cached ) / 8 ) during = heavy querying to optimize the 'Postgresql.conf' setting.

I have 4 s= eparate physical servers and I have all of them set to 512 MB, even though = the results of the formula show.

Server 1     1 GBServer 2     1 GB
Server 3     2 GB
Se= rver 4     2 GB


These results indicate that I sho= uld 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 i= n 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 Mes= senger Caf=E9. Stop by today! = --_ddd12a70-144d-4ebd-924d-73f8bdff7579_--