Re: Change query priority

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/