Re: Fwd: Problems with pg_stat_activity view

From: Kevin Grittner <kgrittn(at)ymail(dot)com>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, mgr inż(dot) Jacek Bzdak <jbzdak(at)gmail(dot)com>
Cc: "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Fwd: Problems with pg_stat_activity view
Date: 2013-11-06 14:28:55
Message-ID: 1383748135.8434.YahooMailNeo@web162904.mail.bf1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Peter Eisentraut <peter_e(at)gmx(dot)net> wrote:
> On 11/2/13, 10:50 PM, Tom Lane wrote:
>> Meh ... that would result in the usename column being possibly
>> NULL, which I bet applications aren't expecting either.  I'm not
>> necessarily against this, but I'm not sure it'll make things
>> much better.  Anybody else have an opinion?
>
> Left join sounds better than accidentally hiding stuff.

+1

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2013-11-06 14:50:33 Re: BUG #8579: CoreDump of background writer process
Previous Message Robert Haas 2013-11-06 13:11:00 Re: [BUGS] BUG #8573: int4range memory consumption