From: Josh Berkus <josh@agliodbs.com>
Reply-To: josh@agliodbs.com
Organization: Aglio Database Solutions
To: pgsql-performance@postgresql.org
Subject: Re: Caching by Postgres
Date: Tue, 23 Aug 2005 10:57:09 -0700
User-Agent: KMail/1.8
Cc: John A Meinel <john@arbash-meinel.com>,
	gokulnathbabu manoharan <gokulnathbabu@yahoo.com>
References: <20050823171045.12112.qmail@web51309.mail.yahoo.com>
	<430B5C27.9030007@arbash-meinel.com>
In-Reply-To: <430B5C27.9030007@arbash-meinel.com>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="utf-8"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200508231057.09885.josh@agliodbs.com>

John,

> So I'm guessing that with 8.1 there would be 2 sweet spots. Low
> shared_buffers (<= 10k), and really high shared buffers (like all of
> available ram).
> But because postgres has been tuned for the former I would stick with it
> (I don't think shared_buffers can go >2GB, but that might just be
> work_mem/maintenance_work_mem).

I'll be testing this as soon as we get some issues with the 64bit 
shared_buffer patch worked out.

-- 
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco