Slow inserts with indentity column
I'm having issue with slow inserts from joined tables into one destination table. I'm using INSERT / SELECT, not row by row insert or similar.
My destination table has 80 columns with IDENTITY(0,1,1) as primary key.
Insert for just 400 records takes 5 seconds.
SELECT statement on joined tables is fast, but when I combine it with INSERT it takes 5 seconds for this amount of records.
Anyway, if I remove IDENTITY column from destination table, it takes just 200 ms.
Is there any proper way how to handle this, because gap between those two results is so huge.
I'm using Vertica inside Docker on Windows environment.