Re: Query Priority - Mailing list pgsql-performance

From Tom Lane
Subject Re: Query Priority
Date
Msg-id 10241.1051885390@sss.pgh.pa.us
Whole thread Raw
In response to Query Priority  (Peter Childs <blue.dragon@blueyonder.co.uk>)
Responses Re: Query Priority
List pgsql-performance
Peter Childs <blue.dragon@blueyonder.co.uk> writes:
>     Is there some way to give some postgres backends higher priority.

No.

>     I don't think this would be too difficult to do as certainly on
> Linux the process could just be reniced and the os left to figure it out.

Read about "priority inversion" in any handy CS textbook ... renicing a
process won't buy you much if the locking mechanisms don't cooperate.

            regards, tom lane


pgsql-performance by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Query Priority
Next
From: "Chad Thompson"
Date:
Subject: Looking for a cheap upgrade (RAID)