Re: IDLE in transaction introspection - Mailing list pgsql-hackers

From Albe Laurenz
Subject Re: IDLE in transaction introspection
Date
Msg-id D960CB61B694CF459DCFB4B0128514C2070C421D@exadv11.host.magwien.gv.at
Whole thread Raw
In response to Re: IDLE in transaction introspection  (Andrew Dunstan <andrew@dunslane.net>)
Responses Re: IDLE in transaction introspection
List pgsql-hackers
Andrew Dunstan wrote:
> On 11/01/2011 09:52 AM, Tom Lane wrote:
>> I'm for just redefining the query field as "current or last
>> query".
>
> +1
>
>> I could go either way on whether to rename it.
>
> Rename it please. "current_query" will just be wrong. I'd be inclined
> just to call it "query" or "query_string" and leave it to the docs to
> define the exact semantics.

+1 for renaming, +1 for a state column.
I think it is overkill to keep a query history beyond that -- if you
want that,
you can resort to the log files.

Yours,
Laurenz Albe


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Hot Backup with rsync fails at pg_clog if under load
Next
From: Simon Riggs
Date:
Subject: Refactor xlog.c #1 - startup.c