From: Greg Smith <gsmith@gregsmith.com>
To: pgsql-performance@postgresql.org
Subject: Re: Migrating to 8.3 - checkpoints and background writer
Date: Sun, 4 Nov 2007 22:06:26 -0500 (EST)
Message-ID: <Pine.GSO.4.64.0711042149270.12181@westnet.com> (raw)
In-Reply-To: <20071105003948.GA25351@uio.no>
References: <Pine.GSO.4.64.0711041912550.29985@westnet.com>
<20071105003948.GA25351@uio.no>
On Mon, 5 Nov 2007, Steinar H. Gunderson wrote:
> I'm a bit puzzled by this part, though: "All tests are on linux with the
> anticipatory I/O scheduler. The default I/O scheduler for Linux is CFQ
> (Completely Fair Queue), which does not work well for PostgreSQL in my
> tests."
The syncronized scan articles were from Jeff Davis and I can't answer for
him. I will say I don't actually agree with that part of the document
myself and almost put a disclaimer to that effect in my message; here it
is now that you bring it up. I suspect the strong preference for avoiding
CFQ in his tests comes from the limitations of how simple (S)ATA drives
are handled in Linux, and that tests with a more robust disk subsystem may
very well give different results. Certainly the adaptive scheduler
appears stronger compared to CFQ as disk seek times go up, and that's the
area where regular hard drives are weakest relative to what's normally in
a server-class system.
--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD
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: gsmith@gregsmith.com
Subject: Re: Migrating to 8.3 - checkpoints and background writer
In-Reply-To: <Pine.GSO.4.64.0711042149270.12181@westnet.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