Re: Re: [COMMITTERS] pgsql: Use LEFT JOINs in some system views in case referenced row doesn - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: Re: [COMMITTERS] pgsql: Use LEFT JOINs in some system views in case referenced row doesn
Date
Msg-id CAB7nPqQbfMjigPAoTRQV+9Kp8FNF=3oz2+_Q+AJmAR118kB=kg@mail.gmail.com
Whole thread Raw
In response to Re: Re: [COMMITTERS] pgsql: Use LEFT JOINs in some system views in case referenced row doesn  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Re: [COMMITTERS] pgsql: Use LEFT JOINs in some system views in case referenced row doesn  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Sun, Sep 11, 2016 at 5:21 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> The fact that the pg_stat_replication view does show walsender processes
> seems like possibly a reasonable argument for not showing them in
> pg_stat_activity.  But we'd have to do some rejiggering of the view
> definition to make that happen.

We may actually had better show WAL sender processes in
pg_stat_activity. An argument in favor of that is the tracking of
WaitEventSet events (or latches if you want).
-- 
Michael



pgsql-hackers by date:

Previous
From: Fabrízio de Royes Mello
Date:
Subject: CommitFest 2016-09 status summary
Next
From: Noah Misch
Date:
Subject: Re: Forbid use of LF and CR characters in database and role names