Re: Change query priority - Mailing list pgsql-general

From Michael Fuhr
Subject Re: Change query priority
Date
Msg-id 20041010160555.GA94113@winnie.fuhr.org
Whole thread Raw
In response to Change query priority  ("Eugeny Balakhonov" <c0ff75@mail.ru>)
Responses Re: Change query priority
List pgsql-general
On Sun, Oct 10, 2004 at 07:12:51PM +0400, Eugeny Balakhonov wrote:
>
> I want to change priority for database queries of this background program to
> "low" and change priority for web site database queries to "high".

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.  This would set the "nice" value of the
backend process, which might serve as a crude prioritization
mechanism.

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

pgsql-general by date:

Previous
From: "Kiarash Bodouhi"
Date:
Subject: Re: Rule problem
Next
From: Tom Lane
Date:
Subject: Re: Change query priority