Re: Batch insert in CTAS/MatView code

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