From: Jim C. Nasby <jim@nasby.net>
To: scott.marlowe <scott.marlowe@ihs.com>
Cc: Matthew Nuzum <cobalt@bearfruit.org>
Cc: Josh Berkus <josh@agliodbs.com>
Cc: Pgsql-Performance <pgsql-performance@postgresql.org>
Subject: Re: choosing the right platform
Date: Wed, 9 Apr 2003 18:47:44 -0500
Message-ID: <20030409184744.W31861@flake.decibel.org> (raw)
In-Reply-To: <Pine.LNX.4.33.0304091152550.22442-100000@css120.ihs.com>
References: <00a001c2febb$631141d0$6900a8c0@mattspc>
<Pine.LNX.4.33.0304091152550.22442-100000@css120.ihs.com>
On Wed, Apr 09, 2003 at 11:55:56AM -0600, scott.marlowe wrote:
> A couple more suggestions. One is to never allocate more than 50% of your
> memory to a database's shared buffers, i.e. let the OS buffer the disks en
> masse, while the database should have a smaller buffer for the most recent
> accesses. This is because kernel caching is usually faster and more
> efficient than the database doing it, and this becomes more an issue with
> large chunks of memory, which both Linux and BSD are quite good at
> caching, and postgresql, not so good.
That seems odd... shouldn't pgsql be able to cache information better
since it would be cached in whatever format is best for it, rather than
the raw page format (or maybe that is the best format). There's also the
issue of having to go through more layers of software if you're relying
on the OS caching. All the tuning info I've seen for every other
database I've worked with specifically recommends giving the database as
much memory as you possibly can, the theory being that it will do a much
better job of caching than the OS will.
--
Jim C. Nasby (aka Decibel!) jim@nasby.net
Member: Triangle Fraternity, Sports Car Club of America
Give your computer some brain candy! www.distributed.net Team #1828
Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-performance@postgresql.org
Cc: jim@nasby.net, scott.marlowe@ihs.com, cobalt@bearfruit.org, josh@agliodbs.com
Subject: Re: choosing the right platform
In-Reply-To: <20030409184744.W31861@flake.decibel.org>
References: <00a001c2febb$631141d0$6900a8c0@mattspc> <Pine.LNX.4.33.0304091152550.22442-100000@css120.ihs.com> <20030409184744.W31861@flake.decibel.org>
* 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