From:
Tatsuo Ishii <ishii(at)postgresql(dot)org>
To:
tgl(at)sss(dot)pgh(dot)pa(dot)us
Cc:
robertmhaas(at)gmail(dot)com, dfontaine(at)hi-media(dot)com, dpage(at)pgadmin(dot)org,
pgsql-hackers(at)postgresql(dot)org
Subject:
Re: Application name patch - v4
Date:
2009-12-01 09:30:03
Message-ID:
20091201.183003.32171609.t-ishii@sraoss.co.jp (view raw or flat )
Thread:
2009-11-26 15:50:15 from Dave Page <dpage(at)pgadmin(dot)org>
2009-11-28 23:47:49 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-11-29 00:27:14 from Joshua Tolley <eggyknap(at)gmail(dot)com>
2009-11-29 01:34:16 from Robert Haas <robertmhaas(at)gmail(dot)com>
2009-11-29 00:51:21 from Andres Freund <andres(at)anarazel(dot)de>
2009-11-29 17:00:54 from Dave Page <dpage(at)pgadmin(dot)org>
2009-11-29 17:22:31 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-11-29 20:03:24 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2009-11-29 23:25:29 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-11-30 00:16:43 from "Florian G(dot) Pflug" <fgp(at)phlo(dot)org>
2009-11-30 07:20:46 from Andres Freund <andres(at)anarazel(dot)de>
2009-11-30 21:11:11 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2009-11-30 21:38:30 from Robert Haas <robertmhaas(at)gmail(dot)com>
2009-11-30 21:54:54 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2009-11-30 22:06:12 from Robert Haas <robertmhaas(at)gmail(dot)com>
2009-11-30 23:59:09 from Bruce Momjian <bruce(at)momjian(dot)us>
2009-12-01 00:11:13 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-12-01 00:26:32 from Andres Freund <andres(at)anarazel(dot)de>
2009-12-01 08:59:17 from Dave Page <dpage(at)pgadmin(dot)org>
2009-12-01 09:11:49 from Andres Freund <andres(at)anarazel(dot)de>
2009-12-01 09:16:45 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2009-12-01 09:18:39 from Dave Page <dpage(at)pgadmin(dot)org>
2009-12-01 16:19:34 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-12-01 16:23:59 from Dave Page <dpage(at)pgadmin(dot)org>
2009-12-01 16:28:22 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-12-01 16:33:54 from Dave Page <dpage(at)pgadmin(dot)org>
2009-12-01 16:52:31 from Marko Kreen <markokr(at)gmail(dot)com>
2009-12-01 18:25:22 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-12-01 20:07:06 from Marko Kreen <markokr(at)gmail(dot)com>
2009-12-01 20:18:31 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-12-01 21:08:06 from Marko Kreen <markokr(at)gmail(dot)com>
2009-12-01 21:20:12 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-12-01 21:30:53 from Marko Kreen <markokr(at)gmail(dot)com>
2009-12-02 05:09:14 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-12-02 08:14:47 from Magnus Hagander <magnus(at)hagander(dot)net>
2009-12-02 08:34:25 from Dave Page <dpage(at)pgadmin(dot)org>
2009-12-02 15:19:33 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-12-01 09:22:13 from Andres Freund <andres(at)anarazel(dot)de>
2009-12-01 10:46:15 from Marko Kreen <markokr(at)gmail(dot)com>
2009-12-01 11:54:03 from Brar Piening <brar(at)gmx(dot)de>
2009-12-01 08:13:58 from Marko Kreen <markokr(at)gmail(dot)com>
2009-12-01 09:30:03 from Tatsuo Ishii <ishii(at)postgresql(dot)org>
2009-11-30 01:01:55 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2009-11-30 01:20:02 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-11-30 02:21:59 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2009-11-30 03:20:53 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
Lists:
pgsql-hackers
> The point is that every other thing you can set in a libpq connection
> string is persistent throughout the connection. For the ones that you
> can change at all, such as client_encoding, *RESET ALL actually resets
> it to what was specified in the connection string*. It does not satisfy
> the POLA for application_name to behave differently.
>
> I think the argument about poolers expecting something different is
> hogwash. A pooler would want RESET ALL to revert the connection state
> to what it was at establishment. That would include whatever
> application name the pooler would have specified when it started the
> connection, I should think.
+1. Connection poolers shoud be transparent to the clients.
If some connection poolers want to behavior differently, then probably
they would be better to be called "TP monitor" or some such. TP
monitor has its own API and it is at liberty behave what it
wants. Don't get me wrong. I would not say TP monitor is useless,
rather it has very usefull use cases I think. However, pushing its
semantics about sessions to PostgreSQL side, would be
counterproductive for both TP monitor and PostgreSQL.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
In response to
pgsql-hackers by date
Next :From: Jeff DavisDate: 2009-12-01 09:43:30Subject : Re: New VACUUM FULLPrevious :From : Andres FreundDate : 2009-12-01 09:22:13Subject : Re: Application name patch - v4
