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