On Thu, May 25, 2006 at 06:16:24PM +0200, Chris Mair wrote:
> I find this very helpful:
>
> Lowering the priority of a PostgreSQL query
> http://weblog.bignerdranch.com/?p=11
>
> Now I was wondering whether one could have a
> SELECT pg_setpriority(10);
> executed automatically each time a certain user
> connects (not necessarily using psql)?
Beware that setting priorities can have unintended, adverse effects.
Use a search engine to find information about "priority inversion"
before deciding that query priorities are a good idea.
--
Michael Fuhr