Horton

Re: Skip partition tuple routing with constant partition key

Zhihong Yu <zyu@yugabyte.com>

View thread View on postgr.es
From: Zhihong Yu <zyu@yugabyte.com>
To: "houzj.fnst@fujitsu.com" <houzj.fnst@fujitsu.com>
Cc: Amit Langote <amitlangote09@gmail.com>, David Rowley <dgrowleyml@gmail.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>, "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
Date: 2021-05-26T17:35:00Z
Lists: pgsql-hackers 
>
> 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 ?

Cheers

Commits

  1. Have ExecFindPartition cache the last found partition

  2. Fix publish_as_relid with multiple publications