From:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:
Marko Kreen <markokr(at)gmail(dot)com>
Cc:
Dave Page <dpage(at)pgadmin(dot)org>,
Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>,
Andres Freund <andres(at)anarazel(dot)de>,
pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>,
Robert Haas <robertmhaas(at)gmail(dot)com>,
Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
Subject:
Re: Application name patch - v4
Date:
2009-12-01 21:20:12
Message-ID:
16595.1259702412@sss.pgh.pa.us (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
Marko Kreen <markokr(at)gmail(dot)com> writes:
> On 12/1/09, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> If you're happy with handling the existing connection parameters in a given
>> way, why would you not want application_name behaving that same way?
> Well, in pgbouncer case, the parameters tracked via ParamStatus are
> handled transparently. (client_encoding, datestyle, timezone,
> standard_conforming_strings)
Hmm, I had not thought about that. Is it sensible to mark
application_name as GUC_REPORT so that pgbouncer can be smart about it?
The actual overhead of such a thing would be probably be unmeasurable in
the normal case where it's only set via the startup packet, but it seems
a bit odd.
regards, tom lane
In response to
Responses
pgsql-hackers by date
Next :From: Joshua D. DrakeDate: 2009-12-01 21:21:51
Subject : Re: SE-PgSQL patch review
Previous :From : Marko KreenDate : 2009-12-01 21:08:06
Subject : Re: Application name patch - v4