Cache tuple routing info during bulk loads into partitioned tables

Edit

ID 3270

Title Cache tuple routing info during bulk loads into partitioned tables

Topic Performance

Created 2021-08-02 06:28:39

Last modified 2022-08-01 22:00:38 (2 years, 3 months ago)

Latest email 2022-08-02 07:19:28 (2 years, 3 months ago)

Status

2022-09: Committed

2022-07: Moved to next CF

2022-03: Moved to next CF

2022-01: Moved to next CF

2021-11: Moved to next CF

2021-09: Moved to next CF

Target version

Authors David Rowley (davidrowley), Amit Langote (amitlan), Hou Zhijie (houzj)

Reviewers Álvaro Herrera (alvherre), David Rowley (davidrowley)Become reviewer

Committer David Rowley (davidrowley)

Links CFbot results (CirrusCI) CFbot GitHub

Checkout latest CFbot patchset

Go to your local checkout of the PostgreSQL repository and run:

git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/3270
git checkout commitfest/cf/3270

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 2022-08-02 07:19:28 by Amit Langote <amitlangote09 at gmail.com>
Latest attachment (v13_cache_last_partition.patch) at 2022-07-28 02:59:21 from David Rowley <dgrowleyml at gmail.com>
    Attachment (v13_cache_last_partition.patch) at 2022-07-28 02:59:21 from David Rowley <dgrowleyml at gmail.com> (Patch: Yes)
    Attachment (v12_cache_last_partition.patch) at 2022-07-26 22:27:53 from David Rowley <dgrowleyml at gmail.com> (Patch: Yes)
    Attachment (v11-0001-WIP-Cache-last-used-partition-in-PartitionDesc.patch) at 2022-07-14 05:30:56 from David Rowley <dgrowleyml at gmail.com> (Patch: Yes)
    Attachment (v10-0001-Optimze-get_partition_for_tuple-by-caching-bound.patch) at 2022-03-25 03:22:39 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v9-0001-Optimze-get_partition_for_tuple-by-caching-bound-.patch) at 2022-03-23 12:52:28 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    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
2022-08-01 22:00:38	David Rowley (davidrowley)	Changed authors to David Rowley (davidrowley), Amit Langote (amitlan), Hou Zhijie (houzj)
2022-08-01 21:59:48	David Rowley (davidrowley)	Closed in commitfest 2022-09 with status: Committed
2022-08-01 21:59:48	David Rowley (davidrowley)	Changed committer to davidrowley
2022-08-01 16:53:31	Jacob Champion (jchampion)	Closed in commitfest 2022-07 with status: Moved to next CF
2022-07-20 20:24:13	David Rowley (davidrowley)	Added davidrowley as reviewer
2022-07-20 20:23:48	David Rowley (davidrowley)	Changed targetversion to None
2022-04-08 14:24:06	Greg Stark (stark)	Closed in commitfest 2022-03 with status: Moved to next CF
2022-02-02 16:33:45	Julien Rouhaud (rjuju)	Closed in commitfest 2022-01 with status: Moved to next CF
2021-12-02 21:40:22	Daniel Gustafsson (d_gustafsson)	Closed in commitfest 2021-11 with status: Moved to next CF
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