Introduce new multi insert Table AM and improve performance of various SQL commands with it for Heap AM

Edit
ID 4777
Title Introduce new multi insert Table AM and improve performance of various SQL commands with it for Heap AM
Topic Server Features
Created 2024-01-16 12:17:34
Last modified 2024-10-05 07:23:52 (1 month ago)
Latest email 2024-10-31 04:17:14 (5 days, 5 hours ago)
Status
2024-11: Needs review
2024-09: Moved to next CF
2024-07: Moved to next CF
2024-03: Moved to next CF
Target version
Authors Bharath Rupireddy (bharathrupireddy)
Reviewers Jeff Davis (jdavis)Become reviewer
Committer
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/4777
git checkout commitfest/cf/4777
Emails
New Table Access Methods for Multi and Single Inserts
First at 2020-12-08 12:57:37 by Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com>
Latest at 2024-10-31 04:17:14 by Jingtang Zhang <mrdrivingduck at gmail.com>
Latest attachment (v25-0001-Introduce-new-table-AM-for-multi-inserts.patch) at 2024-10-30 17:51:23 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com>
    Attachment (v25-0001-Introduce-new-table-AM-for-multi-inserts.patch) at 2024-10-30 17:51:23 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v24-0002-Optimize-CTAS-CMV-RMV-with-new-multi-inserts-tab.patch) at 2024-10-26 13:30:50 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v23-0005-Use-new-multi-insert-table-AM-for-COPY.patch) at 2024-08-26 05:39:28 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v22-0001-Introduce-new-Table-AM-for-multi-inserts.patch) at 2024-06-05 07:12:17 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v21-0001-Introduce-new-Table-Access-Methods-for-single-an.patch) at 2024-05-15 07:26:17 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v20-0001-Introduce-new-Table-Access-Methods-for-single-an.patch) at 2024-04-29 06:06:20 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v19-0001-Introduce-new-Table-Access-Methods-for-single-an.patch) at 2024-04-24 12:49:40 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v18-0001-Introduce-new-table-modify-access-methods.patch) at 2024-04-03 12:25:27 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v17-0001-Introduce-new-table-modify-access-methods.patch) at 2024-04-03 09:02:43 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v16-0001-Introduce-new-table-modify-access-methods.patch) at 2024-03-31 15:48:14 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v15-0001-Introduce-new-table-modify-access-methods.patch) at 2024-03-26 19:49:51 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v14-0001-Introduce-table-modify-access-methods.patch) at 2024-03-25 19:58:00 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v13-0001-New-table-AMs-for-single-and-multi-inserts.patch) at 2024-03-21 07:40:16 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v12-0001-New-TAMs-for-inserts.patch) at 2024-03-08 10:36:59 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v11-0001-New-TAMs-for-inserts.patch) at 2024-03-02 06:32:29 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v10-0001-New-TAMs-for-inserts.patch) at 2024-01-29 11:46:47 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v9-0001-New-TAMs-for-inserts.patch) at 2024-01-29 07:27:00 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v8-0001-New-TAMs-for-inserts.patch) at 2024-01-17 17:27:48 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v7-0001-New-table-AMs-for-single-and-multi-inserts.patch) at 2023-08-01 16:30:00 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v6-0001-New-Table-AMs-for-Multi-and-Single-Inserts.patch) at 2021-04-19 04:51:36 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v5-0001-New-Table-AMs-for-Multi-and-Single-Inserts.patch) at 2021-04-05 04:19:03 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v4-0001-New-Table-AMs-for-Multi-and-Single-Inserts.patch) at 2021-03-10 04:51:53 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v3-0001-New-Table-AMs-for-Multi-and-Single-Inserts.patch) at 2021-02-17 07:16:25 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v2-0001-New-Table-AMs-for-Multi-and-Single-Inserts.patch) at 2020-12-24 00:18:42 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v1-0001-New-Table-AMs-for-Multi-and-Single-Inserts.patch) at 2020-12-08 12:57:37 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
History
When Who What
2024-10-05 07:23:52 Bertrand Drouvot (bertranddrouvot.pg) Closed in commitfest 2024-09 with status: Moved to next CF
2024-08-01 02:04:47 Corey Huinker (coreyh) Closed in commitfest 2024-07 with status: Moved to next CF
2024-04-24 12:51:00 Bharath Rupireddy (bharathrupireddy) Changed name to Introduce new multi insert Table AM and improve performance of various SQL commands with it for Heap AM
2024-04-09 06:24:59 Andrey Borodin (x4m) Closed in commitfest 2024-03 with status: Moved to next CF
2024-03-01 20:30:26 Jeff Davis (jdavis) Changed reviewers to Jeff Davis (jdavis)
2024-01-16 12:17:48 Bharath Rupireddy (bharathrupireddy) Changed authors to Bharath Rupireddy (bharathrupireddy)
2024-01-16 12:17:34 Bharath Rupireddy (bharathrupireddy) Attached mail thread CALj2ACVi9eTRYR=gdca5wxtj3Kk_9q9qVccxsS1hngTGOCjPwQ@mail.gmail.com
2024-01-16 12:17:34 Bharath Rupireddy (bharathrupireddy) Created patch record
Edit