Re: Postgres 11 release notes

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

In response to

Responses

Browse pgsql-hackers by date

  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

Browse pgsql-www by date

  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