| From: | Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com> |
|---|---|
| To: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Cc: | 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-09 10:41:15 |
| Message-ID: | CALj2ACXD4NsUUcM1LTghwKSv3PmjPVKdK5zUBK8ug2i3gsCrQw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Tue, Nov 3, 2020 at 4:54 PM Bharath Rupireddy
<bharath(dot)rupireddyforpostgres(at)gmail(dot)com> wrote:
>
> If the approach followed in the patch looks okay, I can work on a separate patch for multi inserts in refresh materialized view cases.
>
Hi, I'm attaching a v2 patch that has multi inserts for CTAS as well
as REFRESH MATERIALiZED VIEW.
I did some testing: exec time in seconds.
Use case 1: 1 int and 1 text column. each row size 129 bytes, size of
1 text column 101 bytes, number of rows 100million, size of heap file
12.9GB.
HEAD: 220.733, 220.428
Patch: 151.923, 152.484
Thoughts?
With Regards,
Bharath Rupireddy.
EnterpriseDB: http://www.enterprisedb.com
| Attachment | Content-Type | Size |
|---|---|---|
| v2-0001-Multi-Inserts-in-CTAS-Refresh-Materialized-View.patch | application/octet-stream | 17.1 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Magnus Hagander | 2020-11-09 10:42:02 | Re: -O switch |
| Previous Message | Magnus Hagander | 2020-11-09 10:22:56 | Re: pg_upgrade analyze script |