Re: [PERFORM] lowering priority automatically at connection

2006-06-06 Thread Ron Mayer
Tom Lane wrote: 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. I agree that that particular author seems clueless, but

[PERFORM] lowering priority automatically at connection

2006-05-25 Thread Chris Mair
Hi, 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)? Any ideas if and

Re: [PERFORM] lowering priority automatically at connection

2006-05-25 Thread Tom Lane
Chris Mair [EMAIL PROTECTED] 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

Re: [PERFORM] lowering priority automatically at connection

2006-05-25 Thread Chris Mair
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

Re: [PERFORM] lowering priority automatically at connection

2006-05-25 Thread Michael Fuhr
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

Re: [PERFORM] lowering priority automatically at connection

2006-05-25 Thread Christopher Kings-Lynne
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. http://en.wikipedia.org/wiki/Priority_inversion