Re: [PERFORM] lowering priority automatically at connection

2006-06-20 Thread Markus Schaber
Hi, Chris, Chris Mair wrote: > 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 how this might be possible? When using Java, most Datasource implementations

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, bu

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 -

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 c

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 l

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 w

[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 ho