Re: Batch insert in CTAS/MatView code - Mailing list pgsql-hackers

From Bharath Rupireddy
Subject Re: Batch insert in CTAS/MatView code
Date
Msg-id CALj2ACW8i8a5UndOe29Mre-VAiYkA8Y7g8sHFMcLFQxpfEp7sg@mail.gmail.com
Whole thread Raw
In response to RE: Batch insert in CTAS/MatView code  ("tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>)
Responses RE: Batch insert in CTAS/MatView code
List pgsql-hackers
On Wed, May 26, 2021 at 12:18 PM tsunakawa.takay@fujitsu.com
<tsunakawa.takay@fujitsu.com> wrote:
>
> Hello Paul-san,
>
> From: Daniel Gustafsson <daniel@yesql.se>
> > In an off-list discussion with Paul, we decided to withdraw this patch for now
> > and instead create a new entry when there is a re-worked patch.  This has
> > now
> > been done in the CF app.
>
> Would you mind if I take over this patch for PG 15?  I find this promising, as Bharath-san demonstrated good
performanceby combining your patch and the parallel CTAS that Bharath-san has been working on.  We'd like to do things
thatenhance parallelism.
 
>
> Please allow me to start posting the revised patches next week if I can't get your reply.

Hi,

I think the "New Table Access Methods for Multi and Single Inserts"
patches at [1] make multi insert usage easy for COPY, CTAS/Create Mat
View, Refresh Mat View and so on. It also has a patch for multi
inserts in CTAS and Refresh Mat View
(v6-0002-CTAS-and-REFRESH-Mat-View-With-New-Multi-Insert-T.patch).
Please see that thread and feel free to review it.

[1] - https://www.postgresql.org/message-id/CALj2ACXdrOmB6Na9amHWZHKvRT3Z0nwTRsCwoMT-npOBtmXLXg%40mail.gmail.com

With Regards,
Bharath Rupireddy.
EnterpriseDB: http://www.enterprisedb.com



pgsql-hackers by date:

Previous
From: Antonin Houska
Date:
Subject: Possible optimization of heap_lock_tuple()
Next
From: "tsunakawa.takay@fujitsu.com"
Date:
Subject: RE: Batch insert in CTAS/MatView code