Re: lowering priority automatically at connection

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
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:26:43
Message-ID: 13758.1148574403@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Chris Mair <list(at)1006(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message kynn 2006-05-25 16:31:04 Re: Optimizing a huge_table/tiny_table join
Previous Message Kynn Jones 2006-05-25 16:21:53 Re: Optimizing a huge_table/tiny_table join