Buffering Deletes and Updates

The most efficient way you can perform delete and update operations with Vertica is to update many database records at a time using fewer statements. To do this, buffer database deletes and updates in your application before you submit them. That way, you can manage the flow of the delete and update operations so that they do not interfere with normal database performance.

For more information, see Best Practices for DELETEs and UPDATEs in the Administrator's Guide.