Re: ToDo: log plans of cancelled queries

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: ToDo: log plans of cancelled queries
Дата
Msg-id 8747.1357918284@sss.pgh.pa.us
обсуждение исходный текст
Ответ на ToDo: log plans of cancelled queries  (Pavel Stehule <pavel.stehule@gmail.com>)
Ответы Re: ToDo: log plans of cancelled queries  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-hackers
Pavel Stehule <pavel.stehule@gmail.com> writes:
> What do you thinking about this feature?

The idea of expecting an add-on module to execute operations in an
already-failed transaction seems pretty dubious to me.  I also think
it's not a great idea to add partial executions into a query's stats.
For instance, suppose query X has been done 3 times and took a minute
each time.  The fourth time, the user cancels it after one second.
If we now report that the query's average execution time is 45 seconds
or so, that seems pretty misleading to me.
        regards, tom lane



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: allowing privileges on untrusted languages
Следующее
От: Samuel Vogel
Дата:
Сообщение: Re: Print b-tree tuples