Re: IDLE in transaction introspection

Поиск
Список
Период
Сортировка
От Andrew Dunstan
Тема Re: IDLE in transaction introspection
Дата
Msg-id 4EAFFEA0.6010800@dunslane.net
обсуждение исходный текст
Ответ на Re: IDLE in transaction introspection  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: IDLE in transaction introspection  (Jeroen Vermeulen <jtv@xs4all.nl>)
Re: IDLE in transaction introspection  ("Ross J. Reedstrom" <reedstrm@rice.edu>)
Re: IDLE in transaction introspection  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
Список pgsql-hackers

On 11/01/2011 09:52 AM, Tom Lane wrote:
> Simon Riggs<simon@2ndQuadrant.com>  writes:
>> Why not leave it exactly as it is, and add a previous_query column?
>> That gives you exactly what you need without breaking anything.
> That would cost twice as much shared memory for query strings, and twice
> as much time to update the strings, for what seems pretty marginal
> value.  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.

cheers

andrew




В списке pgsql-hackers по дате отправления:

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: unite recovery.conf and postgresql.conf
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: unite recovery.conf and postgresql.conf