Re: Skip partition tuple routing with constant partition key

From: Zhihong Yu <zyu(at)yugabyte(dot)com>
To: Amit Langote <amitlangote09(at)gmail(dot)com>
Cc: "houzj(dot)fnst(at)fujitsu(dot)com" <houzj(dot)fnst(at)fujitsu(dot)com>, David Rowley <dgrowleyml(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com>
Subject: Re: Skip partition tuple routing with constant partition key
Date: 2021-05-27 04:59:56
Message-ID: CALNJ-vTPZ4abZP68fyfDO+kc74WdbWYACms+oCykg4qRsB0XfQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, May 26, 2021 at 9:22 PM Amit Langote <amitlangote09(at)gmail(dot)com>
wrote:

> Hi,
>
> On Thu, May 27, 2021 at 2:30 AM Zhihong Yu <zyu(at)yugabyte(dot)com> wrote:
> >>
> >> Hi, Amit:
> >
> >
> > For ConvertTupleToPartition() in
> 0001-ExecFindPartition-cache-last-used-partition-v3.patch:
> >
> > + if (tempslot != NULL)
> > + ExecClearTuple(tempslot);
> >
> > If tempslot and parent_slot point to the same slot, should
> ExecClearTuple() still be called ?
>
> Yeah, we decided back in 1c9bb02d8ec that it's necessary to free the
> slot if it's the same slot as a parent partition's
> PartitionDispatch->tupslot ("freeing parent's copy of the tuple").
> Maybe we don't need this parent-slot-clearing anymore due to code
> restructuring over the last 3 years, but that will have to be a
> separate patch.
>
> I hope the attached updated patch makes it a bit more clear what's
> going on. I refactored more of the code in ExecFindPartition() to
> make this patch more a bit more readable.
>
> --
> Amit Langote
> EDB: http://www.enterprisedb.com

Hi, Amit:
Thanks for the explanation.

For CanUseSavedPartitionForTuple, nit: you can check
!dispatch->savedPartResultInfo at the beginning and return early.
This would save some indentation.

Cheers

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Langote 2021-05-27 05:40:34 Re: Skip partition tuple routing with constant partition key
Previous Message Dilip Kumar 2021-05-27 04:57:22 Re: Parallel Inserts in CREATE TABLE AS