Re: Statement timeout behavior in extended queries
От | Tatsuo Ishii |
---|---|
Тема | Re: Statement timeout behavior in extended queries |
Дата | |
Msg-id | 20170405.102208.330065229364054347.t-ishii@sraoss.co.jp обсуждение исходный текст |
Ответ на | Re: Statement timeout behavior in extended queries (Tatsuo Ishii <ishii@sraoss.co.jp>) |
Ответы |
Re: Statement timeout behavior in extended queries
|
Список | pgsql-hackers |
>> 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. Hmm. IMO, that could happen even with the current statement timeout implementation as well. Or we could start/stop the timeout in exec_execute_message() only. This could avoid the problem above. Also this is more consistent with log_duration/log_min_duration_statement behavior than now. Best regards, -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese:http://www.sraoss.co.jp
В списке pgsql-hackers по дате отправления: