Re: renice on an I/O bound box - Mailing list pgsql-performance

From Craig Ringer
Subject Re: renice on an I/O bound box
Date
Msg-id 4B5659EB.6080109@postnewspapers.com.au
Whole thread Raw
In response to Re: renice on an I/O bound box  (Arjen van der Meijden <acmmailing@tweakers.net>)
List pgsql-performance
On 20/01/2010 4:16 AM, Arjen van der Meijden wrote:

> Another command to look at, if you're I/O-bound, is the 'ionice'
> command, which is similar to nice, but obviously intended for I/O.
> For some I/O-bound background job, one of the 'idle' classes can be a
> nice level. But for a (single) postgres-process, I'd be careful again
> for the same reasons as with process-nice.

Unfortunately, due to the action of the bgwriter 'ionice' isn't as
effective as you might hope. It's still useful, but it depends on the load.

http://wiki.postgresql.org/wiki/Priorities#Prioritizing_I.2FO

--
Craig Ringer

pgsql-performance by date:

Previous
From: Jeff Davis
Date:
Subject: Re: ext4 finally doing the right thing
Next
From: Andres Freund
Date:
Subject: Re: Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb)