| From: | Justin Pryzby <pryzby(at)telsasoft(dot)com> |
|---|---|
| To: | Paul Guo <guopa(at)vmware(dot)com> |
| Cc: | Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org, "Paul Guo (Pivotal)" <pguo(at)pivotal(dot)io>, Simon Riggs <simon(at)2ndquadrant(dot)com> |
| Subject: | Re: Multi Inserts in CREATE TABLE AS - revived patch |
| Date: | 2020-11-10 15:18:57 |
| Message-ID: | 20201110151857.GO9839@telsasoft.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Tue, Nov 10, 2020 at 10:17:15AM +0000, Paul Guo wrote:
> Raw insert could be used on CTAS & Create MatView. For Refresh MatView the code is a bit
> different. I did not spend more time on this so not sure raw insert could be used for that.
>
> But I think the previous multi insert work could be still used in at least "INSERT tbl SELECT…” (if the INSERT
> is a simple one, e.g. no trigger, no index, etc).
Note that I've started that idea on another thread:
https://commitfest.postgresql.org/30/2553/
- should INSERT SELECT use a BulkInsertState? (and multi_insert)
There's also this one:
https://commitfest.postgresql.org/30/2818/
- split copy.c, Heikki
--
Justin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Georgios Kokolatos | 2020-11-10 15:19:53 | Re: Error on failed COMMIT |
| Previous Message | Georgios Kokolatos | 2020-11-10 15:18:22 | Re: WIP: System Versioned Temporal Table |