Re: Ending EXPLAIN ANALYZE early (was Re: That EXPLAIN ANALYZE patch still needs work)

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Ending EXPLAIN ANALYZE early (was Re: That EXPLAIN ANALYZE patch still needs work)
Дата
Msg-id 12726.1149869915@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Ending EXPLAIN ANALYZE early (was Re: That EXPLAIN ANALYZE patch still needs work)  ("Zeugswetter Andreas DCP SD" <ZeugswetterA@spardat.at>)
Список pgsql-hackers
"Zeugswetter Andreas DCP SD" <ZeugswetterA@spardat.at> writes:
>> This bothers me a bit, because in 
>> fact the effects if any of the tested query would have been 
>> rolled back.  Not sure we have any choice though.  If we 
>> expose the error then we'll have problems with clients not 
>> showing the EXPLAIN results.

> I think we should leave it in top level, throw the error and fix the
> clients.
> As I understood, the idea was, that it only does that if you 
> press ^C or query timeout. In this case current clients would also
> not show the plan.

Not if the clients are implemented per protocol spec.  A client cannot
assume that sending QueryCancel will make the current query fail.
        regards, tom lane


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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: That EXPLAIN ANALYZE patch still needs work
Следующее
От: Tom Lane
Дата:
Сообщение: Re: patch postgresql for AMD64 (Opteron)