From: Josh Berkus <josh@agliodbs.com>
To: pgsql-performance@postgresql.org
Cc: John A Meinel <john@arbash-meinel.com>
Cc: gokulnathbabu manoharan <gokulnathbabu@yahoo.com>
Subject: Re: Caching by Postgres
Date: Tue, 23 Aug 2005 10:57:09 -0700
Message-ID: <200508231057.09885.josh@agliodbs.com> (raw)
In-Reply-To: <430B5C27.9030007@arbash-meinel.com>
References: <20050823171045.12112.qmail@web51309.mail.yahoo.com>
<430B5C27.9030007@arbash-meinel.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: josh@agliodbs.com, john@arbash-meinel.com, gokulnathbabu@yahoo.com
Subject: Re: Caching by Postgres
In-Reply-To: <200508231057.09885.josh@agliodbs.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox