Re: Explain buffers wrong counter with parallel plans

From: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
To: Andres Freund <andres(at)anarazel(dot)de>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, "Jonathan S(dot) Katz" <jonathan(dot)katz(at)excoventures(dot)com>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Adrien Nayrat <adrien(dot)nayrat(at)anayrat(dot)info>, PostgreSQL mailing lists <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Explain buffers wrong counter with parallel plans
Date: 2018-08-02 04:56:44
Message-ID: CAA4eK1Kxhp=EhEV2W1ZCRH_gG0e2Cw-h_Gt+byFpVJAwJ2drwg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Aug 2, 2018 at 8:38 AM, Andres Freund <andres(at)anarazel(dot)de> wrote:
> Hi,
>
> On 2018-08-02 08:21:58 +0530, Amit Kapila wrote:
>> I think something on the lines what Tom and you are suggesting can be
>> done with the help of EXEC_FLAG_BACKWARD, but I don't see the need to
>> do anything for this patch. The change in nodeLimit.c is any way for
>> forward scans, so there shouldn't be any need for any other check.
>
> I think this is almost a guarantee to introduce bugs in the future. And
> besides that, as Robert points out, it's essentially an exiting bug for
> custom scans. Given that EXEC_FLAG_BACKWARD already exists, why not do
> the right thing here?
>

Sure, if we want we can do it in this patch, but this is not the
problem of this patch. It is also related to existing usage of
shutdown callbacks. I think we can use es_top_eflags in Estate to
detect it and then call shutdown only if EXEC_FLAG_BACKWARD is not
set. I think we should do that as a separate patch either before or
after this patch rather than conflating that change into this patch.
IIUC, then Robert also said that we should fix that separately. I
will do as per whatever consensus we reach here.

--
With Regards,
Amit Kapila.
EnterpriseDB: http://www.enterprisedb.com

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Geoghegan 2018-08-02 04:59:48 Re: Making all nbtree entries unique by having heap TIDs participate in comparisons
Previous Message Andrey Lepikhov 2018-08-02 04:48:34 Re: Making all nbtree entries unique by having heap TIDs participate in comparisons