Received: from localhost (uranus.hub.org [200.46.204.60]) by postgresql.org (Postfix) with ESMTP id 40CDB9FB264 for ; Fri, 24 Nov 2006 13:50:41 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.60]) (amavisd-new, port 10024) with ESMTP id 49515-01 for ; Fri, 24 Nov 2006 13:50:38 -0400 (AST) X-Greylist: delayed 00:44:50.584898 by SQLgrey-1.7.4 Received: from home.wiles.org (frank.wiles.org [24.124.39.75]) by postgresql.org (Postfix) with ESMTP id A68849FA3A3 for ; Fri, 24 Nov 2006 13:50:38 -0400 (AST) Received: from localhost.localdomain (frank.wiles.org [24.124.39.75]) by home.wiles.org (8.13.6/8.13.6) with SMTP id kAOH5aQx004359; Fri, 24 Nov 2006 11:05:36 -0600 Date: Fri, 24 Nov 2006 11:04:51 -0600 From: Frank Wiles To: Guido Neitzer Cc: Gopal , Subject: Re: Postgres scalability and performance on windows Message-Id: <20061124110451.4538d901.frank@wiles.org> In-Reply-To: References: X-Mailer: Sylpheed version 2.2.9 (GTK+ 2.8.20; i386-redhat-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/212 X-Sequence-Number: 21982 On Fri, 24 Nov 2006 09:22:45 +0100 Guido Neitzer wrote: > > effective_cache_size = 82728 # typically 8KB each > Hmm. I don't know what the real effect of this might be as the doc > states: > > "This parameter has no effect on the size of shared memory allocated > by PostgreSQL, nor does it reserve kernel disk cache; it is used > only for estimation purposes." This is a hint to the optimizer about how much of the database may be in the OS level cache. --------------------------------- Frank Wiles http://www.wiles.org ---------------------------------