From: Jim C. Nasby <decibel@decibel.org>
To: Heikki Linnakangas <heikki@enterprisedb.com>
Cc: Ron Mayer <rm_pg@cheapcomplexdevices.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: ionice to make vacuum friendier?
Date: Wed, 18 Jul 2007 13:48:16 -0500
Message-ID: <20070718184816.GB39272@nasby.net> (raw)
In-Reply-To: <469DD744.1060906@enterprisedb.com>
References: <f7jfs1$ntm$1@news.hub.org>
<469DD744.1060906@enterprisedb.com>
On Wed, Jul 18, 2007 at 10:03:00AM +0100, Heikki Linnakangas wrote:
> Ron Mayer wrote:
> > Seems Linux has IO scheduling through a program called ionice.
> >
> > Has anyone here experimented with using it rather than
> > vacuum sleep settings?
>
> I looked at that briefly for smoothing checkpoints, but it was
> unsuitable for that purpose because it only prioritizes reads, not writes.
>
> It maybe worth trying for vacuum, though vacuum too can do a lot of
> writes. In the worst case, the OS cache is saturated with dirty pages,
> which blocks all writes in the system.
>
> If it did prioritize writes as well, that would be *excellent*. Any
> kernel hackers out there looking for a project?
My understanding is that FreeBSD will prioritize IO based on process
priority, though I have no idea how it's actually accomplished or how
effective it is. But if we put in special support for this for Linux we
should consider FBSD as well.
--
Jim Nasby decibel@decibel.org
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
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: decibel@decibel.org, heikki@enterprisedb.com, rm_pg@cheapcomplexdevices.com
Subject: Re: ionice to make vacuum friendier?
In-Reply-To: <20070718184816.GB39272@nasby.net>
* 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