Concurrency in Vertica
Posted: Wed Jan 14, 2015 9:42 pm
Hi,
I am new to Vertica and our team is doing a PoC and we need to provide the impact of concurrency in Vertica.
We will be having more than 1500 users hitting or running the dashboard reports concurrently. What should we do to improve the performance of Vertica in such scenario.
I have read the Shilpa Lawande's(VP of Engineering at Vertica) comment on this but she has not mentioned how the customers run thousand concurrent queries in sub seconds:
Prabhjot
I am new to Vertica and our team is doing a PoC and we need to provide the impact of concurrency in Vertica.
We will be having more than 1500 users hitting or running the dashboard reports concurrently. What should we do to improve the performance of Vertica in such scenario.
I have read the Shilpa Lawande's(VP of Engineering at Vertica) comment on this but she has not mentioned how the customers run thousand concurrent queries in sub seconds:
Regards,Scalability has three aspects – data volume, hardware size, and concurrency. Vertica’s performance scales linearly (and often super linearly due to compression and other factors) when you double the data volume or run the same data volume on twice the number of nodes. We have customers who have grown their databases from scratch to over a petabyte, with clusters from tens to hundreds of nodes. As far as concurrency goes, running queries 50-200x faster ensures that we can get a lot more queries done in a unit of time. To efficiently handle a highly concurrent mix of short and long queries, we have built-in workload management that controls how resources are allocated to different classes of queries. Some of our customers run with thousands of concurrent users running sub-second queries.
Prabhjot