Re: Skip partition tuple routing with constant partition key

From: Amit Langote <amitlangote09(at)gmail(dot)com>
To: Zhihong Yu <zyu(at)yugabyte(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 05:40:34
Message-ID: CA+HiwqHv++RKVKRhn7a-=W+obGJkzWy6Yb=mT1XP+1GeRRuZXw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, May 27, 2021 at 1:55 PM Zhihong Yu <zyu(at)yugabyte(dot)com> wrote:
> For CanUseSavedPartitionForTuple, nit: you can check !dispatch->savedPartResultInfo at the beginning and return early.
> This would save some indentation.

Sure, see the attached.

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

Attachment Content-Type Size
v5-0002-ExecPartitionCheck-pre-compute-partition-key-expr.patch application/octet-stream 8.6 KB
v5-0001-ExecFindPartition-cache-last-used-partition.patch application/octet-stream 11.0 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Kapila 2021-05-27 05:48:02 Re: Skipping logical replication transactions on subscriber side
Previous Message Zhihong Yu 2021-05-27 04:59:56 Re: Skip partition tuple routing with constant partition key