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.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file