From: Tom Lane <tgl@sss.pgh.pa.us>
To: Jeff <threshar@torgo.978.org>
Cc: Bruce Momjian <pgman@candle.pha.pa.us>
Cc: Josh Berkus <josh@agliodbs.com>
Cc: Roman Fail <rfail@posportal.com>
Cc: sszabo@megazone23.bigpanda.com <sszabo@megazone23.bigpanda.com>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: 7.3.1 New install, large queries are slow
Date: Fri, 17 Jan 2003 23:49:31 -0500
Message-ID: <21623.1042865371@sss.pgh.pa.us> (raw)
In-Reply-To: <Pine.BSF.4.44.0301171336180.56567-100000@torgo.978.org>
References: <Pine.BSF.4.44.0301171336180.56567-100000@torgo.978.org>
Jeff <threshar@torgo.978.org> writes:
> On Fri, 17 Jan 2003, Tom Lane wrote:
>> Yeah, but isn't that theory a hangover from pre-Unix operating systems?
> Informix, oracle, etc all do raw device access bypassing the kernels
> buffering, etc. So they need heaping gobules of memory to do the same
> thing the kernel does..
D'oh, I believe Jeff's put his finger on it. You need lotsa RAM if you
are trying to bypass the OS. But Postgres would like to work with the
OS, not bypass it.
> but since they know the exact patterns of data and
> how things will be done they can fine tune their buffer caches to get much
> better performance than the kernel (15-20% in informix's case) since the
> kernel needs to be a "works good generally"
They go to all that work for 15-20% ??? Remind me not to follow that
primrose path. I can think of lots of places where we can buy 20% for
less work than implementing (and maintaining) our own raw-device access
layer.
> perhaps a FAQ entry or comment in the shipped config about it?
> I think if people realize it isn't quite the same as what it does in
> oracle/informix/etc then they'll be less inclined to cranking it.
Good thought. But we do need to set the default to something a tad
more realistic-for-2003 than 64 buffers ...
regards, tom lane
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: tgl@sss.pgh.pa.us, threshar@torgo.978.org, pgman@candle.pha.pa.us, josh@agliodbs.com, rfail@posportal.com, sszabo@megazone23.bigpanda.com
Subject: Re: 7.3.1 New install, large queries are slow
In-Reply-To: <21623.1042865371@sss.pgh.pa.us>
References: <Pine.BSF.4.44.0301171336180.56567-100000@torgo.978.org> <21623.1042865371@sss.pgh.pa.us>
* 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