pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedionice to make vacuum friendier?
3+ messages / 3 participants
[nested] [flat]
* ionice to make vacuum friendier?
@ 2007-07-17 22:29 Ron Mayer <rm_pg@cheapcomplexdevices.com>
0 siblings, 1 reply; 3+ messages in thread
From: Ron Mayer @ 2007-07-17 22:29 UTC (permalink / raw)
To: pgsql-performance
Seems Linux has IO scheduling through a program called ionice.
Has anyone here experimented with using it rather than
vacuum sleep settings?
http://linux.die.net/man/1/ionice
This program sets the io scheduling class and priority
for a program. As of this writing, Linux supports 3 scheduling
classes:
Idle. A program running with idle io priority will only get disk
time when no other program has asked for disk io for a defined
grace period. The impact of idle io processes on normal system
activity should be zero.[...]
Best effort. This is the default scheduling class for any process
that hasn't asked for a specific io priority. Programs inherit the
CPU nice setting for io priorities. [...]
http://friedcpu.wordpress.com/2007/07/17/why-arent-you-using-ionice-yet/
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: ionice to make vacuum friendier?
@ 2007-07-18 09:03 Heikki Linnakangas <heikki@enterprisedb.com>
parent: Ron Mayer <rm_pg@cheapcomplexdevices.com>
0 siblings, 1 reply; 3+ messages in thread
From: Heikki Linnakangas @ 2007-07-18 09:03 UTC (permalink / raw)
To: Ron Mayer <rm_pg@cheapcomplexdevices.com>; +Cc: pgsql-performance
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?
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: ionice to make vacuum friendier?
@ 2007-07-18 18:48 Jim C. Nasby <decibel@decibel.org>
parent: Heikki Linnakangas <heikki@enterprisedb.com>
0 siblings, 0 replies; 3+ messages in thread
From: Jim C. Nasby @ 2007-07-18 18:48 UTC (permalink / raw)
To: Heikki Linnakangas <heikki@enterprisedb.com>; +Cc: Ron Mayer <rm_pg@cheapcomplexdevices.com>; pgsql-performance
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)
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2007-07-18 18:48 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-07-17 22:29 ionice to make vacuum friendier? Ron Mayer <rm_pg@cheapcomplexdevices.com>
2007-07-18 09:03 ` Heikki Linnakangas <heikki@enterprisedb.com>
2007-07-18 18:48 ` Jim C. Nasby <decibel@decibel.org>
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