Skip site navigation (1) Skip section navigation (2)

Re: lowering priority automatically at connection

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Chris Mair <list(at)1006(dot)org>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: lowering priority automatically at connection
Date: 2006-05-25 16:54:56
Message-ID: 20060525165456.GA70276@winnie.fuhr.org (view raw or flat)
Thread:
Lists: 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

In response to

pgsql-performance by date

Next:From: Dawid KuroczkoDate: 2006-05-25 17:07:11
Subject: Re: Optimizing a huge_table/tiny_table join
Previous:From: Andrew SullivanDate: 2006-05-25 16:48:40
Subject: Re: Optimizing a huge_table/tiny_table join

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group