Re: Wired if-statement in gen_partprune_steps_internal

From: Amit Langote <amitlangote09(at)gmail(dot)com>
To: Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Wired if-statement in gen_partprune_steps_internal
Date: 2021-03-04 06:03:03
Message-ID: CA+HiwqHsMDQy7oPb9N=x+y60mU-cZf-Ezh8Ym6z3snXsW_1+hg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Oct 20, 2020 at 9:46 PM Amit Langote <amitlangote09(at)gmail(dot)com> wrote:
> On Tue, Oct 20, 2020 at 4:05 PM Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com> wrote:
> > On Wed, Oct 14, 2020 at 11:26 AM Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com> wrote:
> >> On Mon, Oct 12, 2020 at 4:37 PM Amit Langote <amitlangote09(at)gmail(dot)com> wrote:
> >>> I think we should remove this duplicative logic and return the
> >>> generated steps in a list from this function, which the code in
> >>> gen_partprune_steps_internal() then "combines" using an INTERSECT
> >>> step. See attached a patch to show what I mean.
> >>>
> >>
> >> This changes LGTM, and "make check" PASSED, thanks for the patch!
> >>
> >
> > I created https://commitfest.postgresql.org/30/2771/ so that this patch will not
> > be lost. Thanks!
>
> Thanks for doing that.
>
> I had updated the patch last week to address Horiguchi-san's comments
> but didn't manage to post a polished-enough version. I will try again
> this week.

Sorry, this seems to have totally slipped my mind.

Attached is the patch I had promised.

Also, I have updated the title of the CF entry to "Some cosmetic
improvements of partition pruning code", which I think is more
appropriate.

--
Amit Langote
EDB: http://www.enterprisedb.com

Attachment Content-Type Size
v2-0001-Cosmetic-improvements-to-partition-pruning-step-g.patch application/octet-stream 16.3 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Japin Li 2021-03-04 06:10:58 Re: EXPLAIN/EXPLAIN ANALYZE REFRESH MATERIALIZED VIEW
Previous Message Fujii Masao 2021-03-04 05:57:13 Re: PITR promote bug: Checkpointer writes to older timeline