On Tue, Nov 3, 2020 at 4:54 PM Bharath Rupireddy <bharath.rupireddyforpostg...@gmail.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
v2-0001-Multi-Inserts-in-CTAS-Refresh-Materialized-View.patch
Description: Binary data
