Re: lowering priority automatically at connection

Поиск
Список
Период
Сортировка
От Markus Schaber
Тема Re: lowering priority automatically at connection
Дата
Msg-id 44981050.4050109@logix-tt.com
обсуждение исходный текст
Ответ на lowering priority automatically at connection  (Chris Mair <list@1006.org>)
Список pgsql-performance
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 (e. G. the JBoss one)
allow to specify SQL statements that are executed on connection init.

Markus

--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org

В списке pgsql-performance по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Curson prbolem
Следующее
От: "Meetesh Karia"
Дата:
Сообщение: Re: Query hanging/not finishing inconsistently