Re: lowering priority automatically at connection - Mailing list pgsql-performance

From Tom Lane
Subject Re: lowering priority automatically at connection
Date
Msg-id 13758.1148574403@sss.pgh.pa.us
Whole thread Raw
In response to lowering priority automatically at connection  (Chris Mair <list@1006.org>)
Responses Re: lowering priority automatically at connection
Re: lowering priority automatically at connection
Re: lowering priority automatically at connection
List pgsql-performance
Chris Mair <list@1006.org> writes:
> I find this very helpful:
>   Lowering the priority of a PostgreSQL query
>   http://weblog.bignerdranch.com/?p=11

That guy doesn't actually have the foggiest idea what he's doing.
The reason there is no built-in capability to do that is that it *does
not work well*.  Search the list archives for "priority inversion" to
find out why not.

            regards, tom lane

pgsql-performance by date:

Previous
From: Chris Mair
Date:
Subject: lowering priority automatically at connection
Next
From:
Date:
Subject: Re: Optimizing a huge_table/tiny_table join