Skip to main content

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

  • June 7, 2019
  • 1 reply
  • 1 view

abtsantosbenten
Forum|alt.badge.img+1

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.

1 reply

Akash_Manakshe

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