| From: | Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com> |
|---|---|
| To: | "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com> |
| Cc: | Paul Guo <pguo(at)pivotal(dot)io>, Daniel Gustafsson <daniel(at)yesql(dot)se>, Michael Paquier <michael(at)paquier(dot)xyz>, Andres Freund <andres(at)anarazel(dot)de>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Asim R P <apraveen(at)pivotal(dot)io>, Heikki Linnakangas <hlinnaka(at)iki(dot)fi>, PostgreSQL mailing lists <pgsql-hackers(at)postgresql(dot)org>, Taylor Vesely <tvesely(at)pivotal(dot)io> |
| Subject: | Re: Batch insert in CTAS/MatView code |
| Date: | 2021-05-26 07:06:36 |
| Message-ID: | CALj2ACW8i8a5UndOe29Mre-VAiYkA8Y7g8sHFMcLFQxpfEp7sg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Wed, May 26, 2021 at 12:18 PM tsunakawa(dot)takay(at)fujitsu(dot)com
<tsunakawa(dot)takay(at)fujitsu(dot)com> wrote:
>
> Hello Paul-san,
>
> From: Daniel Gustafsson <daniel(at)yesql(dot)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 performance by combining your patch and the parallel CTAS that Bharath-san has been working on. We'd like to do things that enhance 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.
With Regards,
Bharath Rupireddy.
EnterpriseDB: http://www.enterprisedb.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | tsunakawa.takay@fujitsu.com | 2021-05-26 07:19:01 | RE: Batch insert in CTAS/MatView code |
| Previous Message | Antonin Houska | 2021-05-26 07:03:34 | Possible optimization of heap_lock_tuple() |