Re: lowering priority automatically at connection - Mailing list pgsql-performance

From Markus Schaber
Subject Re: lowering priority automatically at connection
Date
Msg-id 44981050.4050109@logix-tt.com
Whole thread Raw
In response to lowering priority automatically at connection  (Chris Mair <list@1006.org>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Curson prbolem
Next
From: "Meetesh Karia"
Date:
Subject: Re: Query hanging/not finishing inconsistently