From: Simon Riggs <simon@2ndquadrant.com>
To: Patrick Vedrines <patrick.vedrines@adpcl.com>
Cc: performance pgsql <pgsql-performance@postgresql.org>
Subject: Re: CPU 0.1% IOWAIT 99% for decisonnal queries
Date: Thu, 24 Mar 2005 21:55:56 +0000
Message-ID: <1111701356.11750.683.camel@localhost.localdomain> (raw)
In-Reply-To: <006801c53056$a4585420$1e0baf96@pcpatrickxp>
References: <002601c52f0a$2312a4d0$280baf96@PCPATRICK>
<1111529891.11750.577.camel@localhost.localdomain>
<006801c53056$a4585420$1e0baf96@pcpatrickxp>
On Thu, 2005-03-24 at 10:48 +0100, Patrick Vedrines wrote:
> > You've got 1.5Gb of shared_buffers and > 2Gb data. In 8.0, the scan
> will
> > hardly use the cache at all, nor will it ever, since the data is
> bigger
> > than the cache. Notably, the scan of B should NOT spoil the cache
> for A
> Are you sure of that ? Is Postgres able to say to OS: "don't use the
> cache for this query"?
PostgreSQL 8.0 has the ARC algorithm which prevents cache spoiling of
the shared_buffers, but has no direct influence over the OS cache.
> > Priming the cache is quite hard...but not impossible.
> > What will kill you on a shared_buffers that big is the bgwriter,
> which
> > you should turn off by setting bgwriter_maxpages = 0
> Is bgwriter concerned as my application applyes only SELECT ?
With very large shared_buffers the bgwriter's default settings are a
problem. You don't need it, so I suggest turning it off.
Best Regards, Simon Riggs
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: simon@2ndquadrant.com, patrick.vedrines@adpcl.com
Subject: Re: CPU 0.1% IOWAIT 99% for decisonnal queries
In-Reply-To: <1111701356.11750.683.camel@localhost.localdomain>
* 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