Re: [HACKERS] Why does logical replication launcher set application_name? - Mailing list pgsql-hackers

From Robert Haas
Subject Re: [HACKERS] Why does logical replication launcher set application_name?
Date
Msg-id CA+TgmoahvHugMoqwMUe+-tABETEutCh6OV7gO7g_dcemSC6cbw@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] Why does logical replication launcher set application_name?  (Michael Paquier <michael.paquier@gmail.com>)
Responses Re: [HACKERS] Why does logical replication launcher set application_name?  (Kuntal Ghosh <kuntalghosh.2007@gmail.com>)
Re: [HACKERS] Why does logical replication launcher setapplication_name?  (Petr Jelinek <petr.jelinek@2ndquadrant.com>)
List pgsql-hackers
On Tue, Apr 11, 2017 at 8:11 PM, Michael Paquier
<michael.paquier@gmail.com> wrote:
> On Wed, Apr 12, 2017 at 3:40 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> I notice looking at pg_stat_activity that the logical replication launcher
>> sets its application_name to "logical replication launcher".  This seems
>> inconsistent (no other standard background process sets application_name),
>> redundant with other columns that already tell you what it is, and an
>> unreasonable consumption of horizontal space in the tabular output.
>> Can we drop that?  If we do have to have something like that, what about
>> putting it in the "query" field where it's much less likely to be
>> substantially wider than any other entry in the column?
>
> It seems to me that the logic behind that is to be able to identify
> easily the logical replication launcher in pg_stat_activity, so using
> the query field instead sounds fine for me as we need another way than
> backend_type to guess what is this bgworker.

Wait, why do we need two ways?

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: [HACKERS] TAP tests take a long time
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Some thoughts about SCRAM implementation