Re: pg_top - Mailing list pgsql-hackers

From Merlin Moncure
Subject Re: pg_top
Date
Msg-id CAHyXU0yw=9d5qR4iiifoN3-jjGiFsc4SpmxkNR02nBYmuigfhA@mail.gmail.com
Whole thread Raw
In response to Re: pg_top  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: pg_top  ("Brett Maton" <matonb@ltresources.co.uk>)
List pgsql-hackers
On Thu, Dec 20, 2012 at 4:17 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> John R Pierce <pierce@hogranch.com> writes:
>> /me tossed another mumbled curse at whomever changed that field name.
>
> The reason for the field name change was that the semantics of the field
> changed.  You typically ought to look at what the application is
> actually doing with the field, not just do s/current_query/query/g
> and expect that all will be well.  (In particular, if the app is looking
> for "idle" or "idle in transaction" state markers, it's going to need
> more adjustment than that.)

IMSNHO, neither of these should have been changed, I would much rather
have seen a new view or some other way of opting into the new
functionality.

merlin



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_top
Next
From: Joshua Berkus
Date:
Subject: Re: Cascading replication: should we detect/prevent cycles?