From: Andrew Sullivan <andrew@libertyrms.info>
To: pgsql-performance@postgresql.org
Subject: Re: 7.3.1 New install, large queries are slow
Date: Fri, 17 Jan 2003 12:59:39 -0500
Message-ID: <20030117125939.J23422@mail.libertyrms.com> (raw)
In-Reply-To: <13109.1042824791@sss.pgh.pa.us>
References: <web-2317350@davinci.ethosmedia.com>
<13109.1042824791@sss.pgh.pa.us>
On Fri, Jan 17, 2003 at 12:33:11PM -0500, Tom Lane wrote:
> One reason not to crank up shared_buffers "just because you can" is that
> there are operations (such as CHECKPOINT) that have to scan through all
> the buffers, linearly. I don't *think* any of these are in
> performance-critical paths, but nonetheless you're wasting CPU. I trust
> the kernel to manage a huge number of buffers efficiently more than I
> trust Postgres.
For what it's worth, we have exactly that experience on our Sun
E4500s. I had machines with 12 gig I was testing on, and I increased
the buffers to 2 Gig, because truss was showing us some sluggishness
in the system was tripping on the system call to get a page. It was
satisifed right away by the kernel's cache, but the system call was
still the most expensive part of the operation.
After we'd increased the shared buffers, however, performance
_degraded_ considerably. It now spent all its time instead managing
the huge shared buffer, and the cost of that was much worse than the
cost of the system call.
So it is extremely dependent on the efficiency of PostgreSQL's use of
shared memory as compared to the efficiency of the system call.
A
--
----
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<andrew@libertyrms.info> M2P 2A8
+1 416 646 3304 x110
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: andrew@libertyrms.info
Subject: Re: 7.3.1 New install, large queries are slow
In-Reply-To: <20030117125939.J23422@mail.libertyrms.com>
References: <web-2317350@davinci.ethosmedia.com> <13109.1042824791@sss.pgh.pa.us> <20030117125939.J23422@mail.libertyrms.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