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-08 05:23:32
Message-ID: 9c76bcab-1804-8c91-b834-5876ae72b9fb@oss.nttdata.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

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.

Regards,

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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message bucoo@sohu.com 2020-05-08 07:13:34 a bug for shm_mq
Previous Message PG Bug reporting form 2020-05-08 00:35:03 BUG #16423: Sequential Scan on query after reindex was done

Browse pgsql-hackers by date

  From Date Subject
Next Message Masahiko Sawada 2020-05-08 05:28:01 Re: Fix pg_buffercache document
Previous Message Andy Fan 2020-05-08 05:08:50 Re: Implementing Incremental View Maintenance