updating rows in vertica is slow

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