updating rows in vertica is slow

Brendon

Hi, I have just join a project where the ETL into the Vertica database takes about 12 hours. When I investigate its cause by updating row into Vertica is slow. Which is to be expected as Vertica is a columns base database.

What are the different work around that make updating database records quick in Vertica. 

Please advise

[Deleted User]

Hi Brendon,

HP Vertica is optimized for query-intensive workloads, so yes as you guessed delete and update queries may not give the same performance. However, there are some guidelines with respect to projection design that can help us optimizing performance for Delete and Update.

Please refer to following section in Vertica Documentation for further help.

Administrator's Guide --> Bulk Deleting & Purging Data --> Best Practices for Deletes & Updates.
(https://my.vertica.com/docs/6.1.x/HTML/index.htm#12703.htm)

And the subsection:

Administrator's Guide --> Bulk Deleting & Purging Data --> Best Practices for Deletes & Updates --> Optimizing DELETEs and UPDATEs for Performance
(https://my.vertica.com/docs/6.1.x/HTML/index.htm#12675.htm)

Thanks,
Pravesh