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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
