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

Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>

From: Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>

To: Jeff Davis <pgsql@j-davis.com>

Cc: Masahiko Sawada <sawada.mshk@gmail.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>, Andres Freund <andres@anarazel.de>, Dilip Kumar <dilipbalaut@gmail.com>, Luc Vlaming <luc@swarm64.com>, Justin Pryzby <pryzby@telsasoft.com>, Michael Paquier <michael@paquier.xyz>, Matthias van de Meent <boekewurm+postgres@gmail.com>, Alexander Korotkov <aekorotkov@gmail.com>

Date: 2024-08-26T05:39:28Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

libpq: Fix some issues in TAP tests for service files
- 2c7bd2ba507e 18.0 cited
Multiple revisions to the GROUP BY reordering tests
- 874d817baa16 17.0 cited
Explore alternative orderings of group-by pathkeys during optimization.
- 0452b461bc40 17.0 cited

Attachments

v23-0005-Use-new-multi-insert-table-AM-for-COPY.patch (application/x-patch) patch v23-0005
v23-0002-Optimize-various-SQL-commands-with-new-multi-ins.patch (application/x-patch) patch v23-0002
v23-0004-Optimize-Logical-Replication-Apply-with-new-mult.patch (application/x-patch) patch v23-0004
v23-0001-Introduce-new-Table-AM-for-multi-inserts.patch (application/x-patch) patch v23-0001
v23-0003-Optimize-INSERT-INTO-SELECT-with-new-multi-inser.patch (application/x-patch) patch v23-0003

On Wed, Jun 5, 2024 at 12:42 PM Bharath Rupireddy
<bharath.rupireddyforpostgres@gmail.com> wrote:
>
> Please find the v22 patches with the above changes.

Please find the v23 patches after rebasing 0005 and adapting 0004 for
9758174e2e.

--
Bharath Rupireddy
PostgreSQL Contributors Team
RDS Open Source Databases
Amazon Web Services: https://aws.amazon.com