Re: Change query priority - Mailing list pgsql-general

From Michael Fuhr
Subject Re: Change query priority
Date
Msg-id 20041010164214.GA94296@winnie.fuhr.org
Whole thread Raw
In response to Re: Change query priority  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Sun, Oct 10, 2004 at 12:29:32PM -0400, Tom Lane wrote:
> Michael Fuhr <mike@fuhr.org> writes:
> > I don't know how effective this would be, but you could wrap the
> > system call setpriority() in a user-defined function if your
> > platform supports it.
>
> Every couple of months someone comes along and says "why don't you
> provide a way to renice a backend" ... but in point of fact it's
> somewhere between useless and counterproductive for most query loads.

I wondered if that might be the case; thanks for pointing out the
reasons, which I now recall having read about before.  I withdraw
the suggestion.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Change query priority
Next
From: Bruno Wolff III
Date:
Subject: Re: OS not good for database