Re: Statement timeout behavior in extended queries

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Statement timeout behavior in extended queries
Дата
Msg-id 18693.1491367191@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Statement timeout behavior in extended queries  (Andres Freund <andres@anarazel.de>)
Ответы Re: Statement timeout behavior in extended queries
Список pgsql-hackers
Andres Freund <andres@anarazel.de> writes:
> On 2017-04-05 10:05:19 +0900, Tatsuo Ishii wrote:
>> What's your point of the question? What kind of problem do you expect
>> if the timeout starts only once at the first parse meesage out of
>> bunch of parse messages?

> It's perfectly valid to send a lot of Parse messages without
> interspersed Sync or Bind/Execute message.  There'll be one timeout
> covering all of those Parse messages, which can thus lead to a timeout,
> even though nothing actually takes long individually.

It might well be reasonable to redefine statement_timeout as limiting the
total time from the first client input to the response to Sync ... but
if that's what we're doing, let's make sure we do it consistently.

I haven't read the patch, but the comments in this thread make me fear
that it's introducing some ad-hoc, inconsistent behavior.
        regards, tom lane



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

Предыдущее
От: David Rowley
Дата:
Сообщение: Re: BRIN cost estimate
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: Compiler warning in costsize.c