Vertica Query Performance
Hi,
I was installed Vertica on single node cluster(with 16GB RAM and 2GB SWAP MEMORY).
I dumped 5 crore data. Intially update peformance was so good. We performed update operations (1,00,000 records updates in 10sec). It continued up to 10 to 15 days only after that the performance was gone into slow down. Now it taking 40sec to update 1,00,000 records. Is there any issues to cause it. To make it fast what we have to do. Is there any memory issues regarding it like cache,garbage. If any how to solve them to make my vertica database as initial performance.
0
Comments
Look into purging deleted data (updates perform a delete / insert):
https://my.vertica.com/docs/9.0.x/HTML/index.htm#Authoring/AdministratorsGuide/BulkDeletingPurging/PurgingDeletedData.htm
And how to tune for Updates and Deletes:
https://my.vertica.com/docs/9.0.x/HTML/index.htm#Authoring/AnalyzingData/Optimizations/OptimizingDELETEsAndUPDATEsForPerformance.htm