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
CI (CFBot) Not processed
Stats (from CFBot) Unknown
Tags
Created 2024-01-16 12:17:34
Last modified 2026-08-04 23:41:56 (1 hour ago)
Latest email 2024-10-31 04:17:14 (1 year ago)
Status
2025-01 (2025-01-01 – 2025-01-31): Withdrawn
2024-11 (2024-11-01 – 2024-11-30): Moved to different CF
2024-09 (2024-09-01 – 2024-09-30): Moved to different CF
2024-07 (2024-07-01 – 2024-07-31): Moved to different CF
2024-03 (2024-03-01 – 2024-04-08): Moved to different CF
Target version
Authors Bharath Rupireddy (bharathrupireddy)
Reviewers Jeff Davis (jdavis) Become reviewer
Committer
Links
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 2026-04-28 04:27:16 by Haibo Yan <tristan.yim 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
2026-08-04 23:41:56 Bharath Rupireddy (bharathrupireddy) Closed in commitfest 2025-01 with status: Withdrawn
2024-12-11 05:01:36 Michael Paquier (michael-kun) Closed in commitfest 2024-11 with status: Moved to next CF
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