Skip site navigation (1) Skip section navigation (2)

Re: renice on an I/O bound box

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To: Arjen van der Meijden <acmmailing(at)tweakers(dot)net>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: renice on an I/O bound box
Date: 2010-01-20 01:18:35
Message-ID: 4B5659EB.6080109@postnewspapers.com.au (view raw or flat)
Thread:
Lists: 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

In response to

pgsql-performance by date

Next:From: Andres FreundDate: 2010-01-20 04:01:55
Subject: Re: Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb)
Previous:From: Jeff DavisDate: 2010-01-19 23:28:34
Subject: Re: ext4 finally doing the right thing

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group