From: | Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp> |
---|---|
To: | bruce(at)momjian(dot)us |
Cc: | ishii(at)sraoss(dot)co(dot)jp, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Postgres 11 release notes |
Date: | 2018-05-15 00:51:47 |
Message-ID: | 20180515.095147.2115329688197150115.t-ishii@sraoss.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-www |
>> I could not find this:
>>
>> $ git log -1 f8e5f15
>> commit f8e5f156b30efee5d0038b03e38735773abcb7ed
>> Author: Andres Freund <andres(at)anarazel(dot)de>
>> Date: Mon Sep 18 19:36:44 2017 -0700
>>
>> Rearm statement_timeout after each executed query.
>>
>> Previously statement_timeout, in the extended protocol, affected all
>> messages till a Sync message. For clients that pipeline/batch query
>> execution that's problematic.
>>
>> Instead disable timeout after each Execute message, and enable, if
>> necessary, the timer in start_xact_command(). As that's done only for
>> Execute and not Parse / Bind, pipelining the latter two could still
>> cause undesirable timeouts. But a survey of protocol implementations
>> shows that all drivers issue Sync messages when preparing, and adding
>> timeout rearming to both is fairly expensive for the common parse /
>> bind / execute sequence.
>>
>> Author: Tatsuo Ishii, editorialized by Andres Freund
>> Reviewed-By: Takayuki Tsunakawa, Andres Freund
>> Discussion: https://postgr.es/m/20170222.115044.1665674502985097185.t-ishii@sraoss.co.jp
>
> That seemed too detailed for the release notes. Is that wrong?
This commit gives user-visible changes to the statment timeout
behavior. So I think this should be added to the release notes.
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
From | Date | Subject | |
---|---|---|---|
Next Message | 自己 | 2018-05-15 01:55:48 | Re:Re: some question about _bt_getbuf |
Previous Message | Amit Langote | 2018-05-15 00:47:24 | Re: Indexes on partitioned tables and foreign partitions |
From | Date | Subject | |
---|---|---|---|
Next Message | Dang Minh Huong | 2018-05-15 03:12:15 | Re: Postgres 11 release notes |
Previous Message | Bruce Momjian | 2018-05-15 00:46:42 | Re: Postgres 11 release notes |