| From: | Michael Paquier <michael(at)paquier(dot)xyz> |
|---|---|
| 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-07 02:33:00 |
| Message-ID: | 20190307023300.GG17293@paquier.xyz |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi,
On Wed, Mar 06, 2019 at 10:06:27PM +0800, Paul Guo wrote:
> 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. That was done by Taylor (cc-ed) and me.
Please note that we are currently in the last commit fest of Postgres
12, and it is too late to propose new features. Please feel free to
add an entry to the commit fest happening afterwards.
--
Michael
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andres Freund | 2019-03-07 02:38:38 | Re: pg_dump is broken for partition tablespaces |
| Previous Message | Michael Paquier | 2019-03-07 02:30:29 | Re: pgsql: tableam: introduce table AM infrastructure. |