Cache tuple routing info during bulk loads into partitioned tables

Edit
Title Cache tuple routing info during bulk loads into partitioned tables
Topic Performance
Created 2021-08-02 06:28:39
Last modified 2021-10-04 07:22:42 (2 weeks, 2 days ago)
Latest email 2021-08-02 06:29:37 (2 months, 2 weeks ago)
Status
2021-11: Needs review
2021-09: Moved to next CF
Target version 15
Authors Amit Langote (amitlan), Hou Zhijie (houzj)
Reviewers Álvaro Herrera (alvherre)Become reviewer
Committer
Links
Emails
Skip partition tuple routing with constant partition key
First at 2021-05-17 11:36:48 by "houzj.fnst at fujitsu.com" <houzj.fnst at fujitsu.com>
Latest at 2021-08-02 06:29:37 by Amit Langote <amitlangote09 at gmail.com>
Latest attachment (v8-0001-Teach-get_partition_for_tuple-to-cache-bound-offs.patch) at 2021-08-02 06:29:37 from Amit Langote <amitlangote09 at gmail.com>
    Attachment (v8-0001-Teach-get_partition_for_tuple-to-cache-bound-offs.patch) at 2021-08-02 06:29:37 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v7-0001-Teach-get_partition_for_tuple-to-cache-bound-offs.patch) at 2021-06-17 05:36:47 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v6-0001-Teach-get_partition_for_tuple-to-cache-bound-offs.patch) at 2021-06-17 04:28:58 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v5-0001-adpative-bound-offset-caching-v5.patch) at 2021-06-16 07:27:45 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (0001-WIP-cache-bound-offset-adaptively_v4.patch) at 2021-06-07 11:38:40 from "houzj.fnst at fujitsu.com" <houzj.fnst at fujitsu.com> (Patch: Yes)
    Attachment (0001-cache-bound-offset_v3.patch) at 2021-06-04 09:05:17 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (0001-cache-bound-offset_v2.patch) at 2021-06-04 07:38:38 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (0001-cache-bound-offset.patch) at 2021-06-01 08:43:05 from "houzj.fnst at fujitsu.com" <houzj.fnst at fujitsu.com> (Patch: Yes)
    Attachment (v5-0002-ExecPartitionCheck-pre-compute-partition-key-expr.patch) at 2021-05-27 05:40:34 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (0002-ExecPartitionCheck-pre-compute-partition-key-express.patch) at 2021-05-27 04:22:01 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (0001-ExecFindPartition-cache-last-used-partition-v3.patch) at 2021-05-25 14:05:39 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (0001-recursive-search-parent-partkeyexpr.patch) at 2021-05-24 13:15:35 from "houzj.fnst at fujitsu.com" <houzj.fnst at fujitsu.com> (Patch: Yes)
    Attachment (ExecPartitionCheck-eval-partexprs-once-PoC_v1.patch) at 2021-05-24 08:27:02 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (0001-improving-ExecPartitionCheck.patch) at 2021-05-24 08:17:34 from "houzj.fnst at fujitsu.com" <houzj.fnst at fujitsu.com> (Patch: Yes)
    Attachment (0001-improving-ExecPartitionCheck.patch) at 2021-05-24 01:31:44 from "houzj.fnst at fujitsu.com" <houzj.fnst at fujitsu.com> (Patch: Yes)
    Attachment (ExecFindPartition-cache-partition-PoC_v2.patch) at 2021-05-20 08:49:20 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (ExecFindPartition-cache-partition-PoC.patch) at 2021-05-19 13:17:19 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (0001-skip-tuple-routing-for-constant-partition-key.patch) at 2021-05-17 11:36:48 from "houzj.fnst at fujitsu.com" <houzj.fnst at fujitsu.com> (Patch: Yes)
History
When Who What
2021-10-04 07:22:42 Jaime Casanova (jcasanov) Closed in commitfest 2021-09 with status: Moved to next CF
2021-09-01 16:29:48 Álvaro Herrera (alvherre) Changed reviewers to Álvaro Herrera (alvherre)
2021-08-02 06:29:09 Amit Langote (amitlan) Changed authors to Amit Langote (amitlan), hou zhijie (houzj)
2021-08-02 06:29:09 Amit Langote (amitlan) Changed targetversion to 15
2021-08-02 06:29:09 Amit Langote (amitlan) Changed name to Cache tuple routing info during bulk loads into partitioned tables
2021-08-02 06:28:40 Amit Langote (amitlan) Attached mail thread OS0PR01MB571649B27E912EA6CC4EEF03942D9@OS0PR01MB5716.jpnprd01.prod.outlook.com
2021-08-02 06:28:39 Amit Langote (amitlan) Created patch record
Edit