Copy data inside Vertica

Mike_Gong_1

Hi, I'm wondering what the best way is to load data from one table to another table in the same Vertica database. I'm currently loading data from staging table to target DW table using SELECT INSERT. It seems to be very slow. Is there any faster approach or I just need to tune the database? Thanks

Navin_C

Hello Mike I think you need to tune the database. Check with your target table projections, If there are many projections, this can be time consuming as the data has to be loaded into all projections. Hope this helps.

[Deleted User]

Hey all, Navin, thanks for the reply! I'd agree, INSERT SELECT is the fastest way to do this, time to tune this database. A specific bit of tuning: Do your staging and target tables have exactly the same projections? (Exact same sort order, segmentation, partitioning, etc.) That one detail makes a big difference -- it means INSERT SELECT already has all the data on the same node in the right format, rather than having to re-sort it and ship it around the network. Adam