Re: lowering priority automatically at connection

From: Markus Schaber <schabi(at)logix-tt(dot)com>
To: Chris Mair <list(at)1006(dot)org>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: lowering priority automatically at connection
Date: 2006-06-20 15:12:16
Message-ID: 44981050.4050109@logix-tt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Meetesh Karia 2006-06-20 17:25:19 Re: Query hanging/not finishing inconsistently
Previous Message Tom Lane 2006-06-20 14:28:18 Re: Curson prbolem