How to improve INSERT...SELECT * FROM table - 70GB data

abtsantosbentenabtsantosbenten Registered User

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.

Comments

  • Akash_ManaksheAkash_Manakshe Registered User

    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....

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file