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
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 |