X-Original-To: pgsql-performance-postgresql.org@postgresql.org
Received: from localhost (mx1.hub.org [200.46.208.251])
	by postgresql.org (Postfix) with ESMTP id E6FA59FA60A
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Tue, 20 Jun 2006 12:12:21 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024)
	with ESMTP id 52792-02 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Tue, 20 Jun 2006 12:12:16 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from mail.logix-tt.com (mail.logix-tt.com [212.211.145.186])
	by postgresql.org (Postfix) with ESMTP id 0F1EB9FA219
	for <pgsql-performance@postgresql.org>;
	Tue, 20 Jun 2006 12:12:14 -0300 (ADT)
Received: from kingfisher.intern.logix-tt.com (T8ef4.t.pppool.de
	[89.55.142.244])
	(using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits))
	(No client certificate requested)
	by mail.logix-tt.com (Postfix) with ESMTP id 61F2E6587A;
	Tue, 20 Jun 2006 17:13:42 +0200 (CEST)
Received: from [127.0.0.1] (localhost [127.0.0.1])
	by kingfisher.intern.logix-tt.com (Postfix) with ESMTP id 1C2981852E435;
	Tue, 20 Jun 2006 17:12:17 +0200 (CEST)
Message-ID: <44981050.4050109@logix-tt.com>
Date: Tue, 20 Jun 2006 17:12:16 +0200
From: Markus Schaber <schabi@logix-tt.com>
Organization: Logical Tracking and Tracing International AG, Switzerland
User-Agent: Thunderbird 1.5.0.2 (X11/20060516)
MIME-Version: 1.0
To: Chris Mair <list@1006.org>
Cc: pgsql-performance@postgresql.org
Subject: Re: lowering priority automatically at connection
References: <1148573784.6017.26.camel@dell.home.lan>
In-Reply-To: <1148573784.6017.26.camel@dell.home.lan>
X-Enigmail-Version: 0.94.0.0
Content-Type: text/plain; charset=ISO-8859-15
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200606/387
X-Sequence-Number: 19744

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