X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 548B3D1C9E1 for ; Mon, 15 Mar 2004 20:09:36 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 67784-05 for ; Mon, 15 Mar 2004 16:09:34 -0400 (AST) Received: from fep01-mail.bloor.is.net.cable.rogers.com (fep01-mail.bloor.is.net.cable.rogers.com [66.185.86.71]) by svr1.postgresql.org (Postfix) with ESMTP id 12898D1C969 for ; Mon, 15 Mar 2004 16:09:31 -0400 (AST) Received: from phlogiston.dydns.org ([65.49.121.67]) by fep01-mail.bloor.is.net.cable.rogers.com (InterMail vM.5.01.05.12 201-253-122-126-112-20020820) with ESMTP id <20040315200907.QCWR230350.fep01-mail.bloor.is.net.cable.rogers.com@phlogiston.dydns.org> for ; Mon, 15 Mar 2004 15:09:07 -0500 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id 08E4D3DC8; Mon, 15 Mar 2004 15:09:31 -0500 (EST) Date: Mon, 15 Mar 2004 15:09:31 -0500 From: Andrew Sullivan To: pgsql-performance@postgresql.org Subject: Re: Scaling further up Message-ID: <20040315200930.GA2921@phlogiston.dyndns.org> Mail-Followup-To: pgsql-performance@postgresql.org References: <4BAFBB6B9CC46F41B2AD7D9F4BBAF785098062@vt-pe2550-001.vantage.vantage.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <4BAFBB6B9CC46F41B2AD7D9F4BBAF785098062@vt-pe2550-001.vantage.vantage.com> User-Agent: Mutt/1.5.5.1+cvs20040105i X-Authentication-Info: Submitted using SMTP AUTH LOGIN at fep01-mail.bloor.is.net.cable.rogers.com from [65.49.121.67] using ID at Mon, 15 Mar 2004 15:09:07 -0500 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/197 X-Sequence-Number: 6053 On Fri, Mar 12, 2004 at 06:25:48PM -0500, Anjan Dave wrote: > We upgraded from 8GB to 12GB RAM a month or so ago, but even in the > past, I've never seen the system exhaust on it's system cache (~6GB, in > 'top'), while it's swapping. > > Some one had mentioned why not have the entire DB in memory? How do I > configure that, for knowledge? You don't. It'll automatically be in memory if (a) you have enough memory, (b) you don't have anything else on the machine using the memory, and (c) it's been read at least one time. A -- Andrew Sullivan | ajs@crankycanuck.ca