| From: | David Fetter <david(at)fetter(dot)org> |
|---|---|
| To: | Paul Guo <pguo(at)pivotal(dot)io> |
| Cc: | pgsql-hackers(at)postgresql(dot)org, Taylor Vesely <tvesely(at)pivotal(dot)io> |
| Subject: | Re: Batch insert in CTAS/MatView code |
| Date: | 2019-03-10 18:58:07 |
| Message-ID: | 20190310185807.GA27583@fetter.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Wed, Mar 06, 2019 at 10:06:27PM +0800, Paul Guo wrote:
> Hello, Postgres hackers,
>
> The copy code has used batch insert with function heap_multi_insert() to
> speed up. It seems that Create Table As or Materialized View could leverage
> that code also to boost the performance also. Attached is a patch to
> implement that.
This is great!
Is this optimization doable for multi-row INSERTs, either with tuples
spelled out in the body of the query or in constructs like INSERT ...
SELECT ...?
Best,
David.
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2019-03-10 19:18:20 | pgsql: Include GUC's unit, if it has one, in out-of-range error message |
| Previous Message | Peter Geoghegan | 2019-03-10 18:53:08 | Re: Making all nbtree entries unique by having heap TIDs participate in comparisons |