From: Jim C. Nasby <jim@nasby.net>
To: Brian Wipf <brian@clickspace.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Dave Cramer <pg@fastcrypt.com>
Cc: pgsql-performance@postgresql.org, Guido Neitzer <lists@event-s.net>
Subject: Re: shared_buffers > 284263 on OS X
Date: Sun, 26 Nov 2006 17:25:23 -0600
Message-ID: <20061126232523.GD39519@nasby.net> (raw)
In-Reply-To: <817D9C4C-05F0-45FB-9D63-B63CFE2C009E@clickspace.com>
References: <B242A585-E94C-4ECA-8FA9-DCE72E1D8838@shoptoit.ca>
<82E59D2F-0946-4405-8F11-4CF5184A9399@fastcrypt.com>
<412.1163874633@sss.pgh.pa.us>
<817D9C4C-05F0-45FB-9D63-B63CFE2C009E@clickspace.com>
On Sat, Nov 18, 2006 at 08:13:26PM -0700, Brian Wipf wrote:
> It certainly is unfortunate if Guido's right and this is an upper
> limit for OS X. The performance benefit of having high shared_buffers
> on our mostly read database is remarkable.
Got any data about that you can share? People have been wondering about
cases where drastically increasing shared_buffers makes a difference.
--
Jim Nasby jim@nasby.net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
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: jim@nasby.net, brian@clickspace.com, tgl@sss.pgh.pa.us, pg@fastcrypt.com, lists@event-s.net
Subject: Re: shared_buffers > 284263 on OS X
In-Reply-To: <20061126232523.GD39519@nasby.net>
* 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