Re: Back-patch is necessary? Re: Don't try fetching future segment of a TLI.

From: Fujii Masao <masao(dot)fujii(at)oss(dot)nttdata(dot)com>
To: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
Cc: David Steele <david(at)pgmasters(dot)net>, Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>, psuderevsky(at)gmail(dot)com, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: Back-patch is necessary? Re: Don't try fetching future segment of a TLI.
Date: 2020-05-09 03:26:22
Message-ID: 9d7ad280-9ce8-a538-83a3-29c57583f1ef@oss.nttdata.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

On 2020/05/08 14:23, Fujii Masao wrote:
>
>
> On 2020/05/07 17:57, Amit Kapila wrote:
>> On Thu, May 7, 2020 at 12:13 PM Fujii Masao <masao(dot)fujii(at)oss(dot)nttdata(dot)com> wrote:
>>>
>>> On 2020/05/02 20:40, Amit Kapila wrote:
>>>>
>>>> I don't see any obvious problem with the changed code but we normally
>>>> don't backpatch performance improvements.  I can see that the code
>>>> change here appears to be straight forward so it might be fine to
>>>> backpatch this.  Have we seen similar reports earlier as well?  AFAIK,
>>>> this functionality is for a long time and if people were facing this
>>>> on a regular basis then we would have seen such reports multiple
>>>> times.  I mean to say if the chances of this hitting are less then we
>>>> can even choose not to backpatch this.
>>>
>>> I found the following two reports. ISTM there are not so many reports...
>>> https://www.postgresql.org/message-id/16159-f5a34a3a04dc67e0@postgresql.org
>>> https://www.postgresql.org/message-id/dd6690b0-ec03-6b3c-6fac-c963f91f87a7%40postgrespro.ru
>>>
>>
>> The first seems to be the same where this bug has been fixed.  It has
>> been moved to hackers in email [1].
>
> Yes, that's the original report that leaded to the commit.
>
>>  Am, I missing something?
>> Considering it has been encountered by two different people, I think
>> it would not be a bad idea to back-patch this.
>
> +1 So I will do the back-patch.

Done. Thanks!

Regards,

--
Fujii Masao
Advanced Computing Technology Center
Research and Development Headquarters
NTT DATA CORPORATION

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2020-05-09 12:44:53 BUG #16426: In active/hot standby mode, create database and drop template databases cause standby restart failed
Previous Message Thusitha Maheepala 2020-05-09 02:33:47 Postgredb issue

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2020-05-09 04:17:48 Re: Should smgrdounlink() be removed?
Previous Message Melanie Plageman 2020-05-09 01:58:10 Re: Avoiding hash join batch explosions with extreme skew and weird stats