Is Vertica Clustering Increase Performance?
Hi, we have a system with high volume bulk load, for now we load 10 k data per second
and retain data for 10 days...
But in future we need scale our system and should handle 50 k data per second
and we should retain data for 20 days.
For now, we use Vertica in single Node, and after 5 or 6 TB, simple queries like count(*) take long time.
I know clustering is good for high availability, but we need performance optimization in 2 phase:
bulk loading and query execution.
Is Clustering increase performance in bulk loading and query execution?