How to improve INSERT...SELECT * FROM table - 70GB data
using Vertica 9.0, 8 nodes, 170GB in general pool each node
the following statement inserts 70GB worth of data (compressed) for 100 mins. Can this still be improved to 30 mins?
INSERT /+direct/ INTO mytable SELECT * FROM anothertable;
I can't use COPY_TABLE because the table projections are different and will always be different because of the process logic.
0
Comments
Try to Create Projections 9& buddy Projection) on Same Nodes as of Parent Table (Create Projection of Insert Table from same node as of Parent Table), this will reduce moving of data between Nodes....