From: Jim C. Nasby <decibel@decibel.org>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Tobias Brox <tobias@nordicbet.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: "nice"/low priority Query
Date: Tue, 2 Aug 2005 12:25:50 -0500
Message-ID: <20050802172550.GZ60019@decibel.org> (raw)
In-Reply-To: <11484.1122999570@sss.pgh.pa.us>
References: <20050802160434.GD9278@tobias.lan>
<11484.1122999570@sss.pgh.pa.us>
On Tue, Aug 02, 2005 at 12:19:30PM -0400, Tom Lane wrote:
> Tobias Brox <tobias@nordicbet.com> writes:
> > Is there any ways to give postgresql a hint that a
> > particular SQL call should be run at lower priority? Since every db
> > connection has a pid, I can manually run "renice" to scheduele it by the OS
> > - but of course I can't do it manually all the time.
>
> And it won't help you anyway, because renice only affects CPU priority
> not I/O scheduling ... which, by your description, is the real problem.
Actually, from what I've read 4.2BSD actually took priority into account
when scheduling I/O. I don't know if this behavior is still present in
FreeBSD or the like, though. So depending on the OS, priority could play
a role in determining I/O scheduling.
--
Jim C. Nasby, Database Consultant decibel@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828
Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: decibel@decibel.org, tgl@sss.pgh.pa.us, tobias@nordicbet.com
Subject: Re: "nice"/low priority Query
In-Reply-To: <20050802172550.GZ60019@decibel.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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