Unix Technical Forum

ionice to make vacuum friendier?

This is a discussion on ionice to make vacuum friendier? within the Pgsql Performance forums, part of the PostgreSQL category; --> Seems Linux has IO scheduling through a program called ionice. Has anyone here experimented with using it rather than ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > Pgsql Performance

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  1 links from elsewhere to this Post. Click to view. #1 (permalink)  
Old 04-19-2008, 10:13 AM
Ron Mayer
 
Posts: n/a
Default ionice to make vacuum friendier?

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/0...ng-ionice-yet/
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 04-19-2008, 10:13 AM
Heikki Linnakangas
 
Posts: n/a
Default Re: ionice to make vacuum friendier?

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

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 04-19-2008, 10:14 AM
Jim C. Nasby
 
Posts: n/a
Default Re: ionice to make vacuum friendier?

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)

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.3 (FreeBSD)

iD8DBQFGnmBwdO30qud8SkgRAvGkAJ9rhl9LVn8XeqtsZUx+Go InIdIotACghXE+
2tjQHAt3gJen8LDSBSeAsD4=
=7eRf
-----END PGP SIGNATURE-----

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump

LinkBacks (?)
LinkBack to this Thread: http://www.unixadmintalk.com/pgsql-performance/352104-ionice-make-vacuum-friendier.html

Posted By For Type Date
???? This thread Refback 06-05-2008 10:19 AM


All times are GMT. The time now is 01:54 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com