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

From Michael Fuhr
Subject Re: lowering priority automatically at connection
Date
Msg-id 20060525165456.GA70276@winnie.fuhr.org
Whole thread Raw
In response to lowering priority automatically at connection  (Chris Mair <list@1006.org>)
List pgsql-performance
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

pgsql-performance by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Optimizing a huge_table/tiny_table join
Next
From: "Dawid Kuroczko"
Date:
Subject: Re: Optimizing a huge_table/tiny_table join