Vertica Scalability

Sima Alexandru - PeerSpot reviewer
Support Specialis at Orion Innovation Romania

Around 100 people in my company use Vertica.

View full review »
SE
Project Manager at Bank of Africa

The solution is easy to scale.

We have seven people using the solution.

View full review »
SO
Senior Database Architect at a real estate/law firm with 501-1,000 employees

It is scalable. You just add extra nodes. But like all data solutions and all databases, you have to always consider how the data is stored, and how the data is queried. We have Elasticsearch and several other database. They will perform differently when used for different tasks. The right database for the right task.

Vertica is really quick, but with poor query design a report can take far too long. 
Vertice EON mode allows for true user / query type scalability by firing up additional clusters as requirements change

View full review »
Buyer's Guide
Vertica
March 2024
Learn what your peers think about Vertica. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
767,847 professionals have used our research since 2012.
SR
Pathways Operations Manager at a retailer with 10,001+ employees

Vertica is a scalable solution.

I would rate the scalability an eight or nine out of ten based on the use case that we do.

We are a team that handles operational reporting, and our Vertica implementation is used by thousands of people. However, the team responsible for managing and writing code for Vertica consists of only around ten to twelve people.

View full review »
it_user514728 - PeerSpot reviewer
Senior DBA at a local government with 1,001-5,000 employees

I have not encountered any scalability issues.

View full review »
SK
Group DWH and BI Senior Manager at Virgin Mobile Middle East and Africa

Vertica is scalable.

View full review »
TE
Senior Manager, Systems and Network Engineering at a computer software company with 11-50 employees

Scalability has been amazing. We have seen a lot of improvement. We have developers and we have a production demo. We have hosted clusters for customers, we have deployed customer scope. I can scribe them by petabytes. I can scale them by the number of users. It depends on the customers. For one project we can have 15 to 20 consecutive users, but they deal with petabytes of storage.

View full review »
it_user453681 - PeerSpot reviewer
BI Manager, Vertica ASE Certified DBA at a marketing services firm with 1,001-5,000 employees

No issues. Amazingly scalable.

Adding one node was very easy, as was adding memory to all nodes. We are currently in the process of setting up a Dev / DR environment which is going very smoothly.

View full review »
AA
Staff Database Developer at a manufacturing company with 10,001+ employees

The scalability of Vertica is good.

We have approximately 100 users using this solution.

View full review »
MG
Senior Technology Architect at a tech vendor with 10,001+ employees

It is a scalable solution. Initially, we had issues with the scalability, but with the new version, Vertica resolved the issues.

Regarding how many users are using this solution, I do not have a specific number, but our organization is large. So, for example, in a unit with about fifteen clients, two to three clients use Vertica.

View full review »
it_user428343 - PeerSpot reviewer
Managing Partner at Thorium Data Science

We've had no issues scaling it.

View full review »
AG
Director at Decision Science
BS
Group Chief Technology Officer at Netcore Solutions

Vertica seems to scale well, except for one use case where you are on a multi-node cluster. For example, if you had a nine-node cluster, one node goes down, then the eight nodes don't scale, because the absence of the node is very apparent, which is a problem. If you have nine nodes or multiple nodes, the whole idea is that if one of those nodes goes down, then you should not see an impact on the system if you have enough capacity. Even though we have enough capacity, you can still see the impact of the one node going down.

We have approximately 25 people using this solution in my company. Most of the users are developers. We have been increasing usage of the solution.

View full review »
YZ
Sr DBA/ DBA Tech Lead at a non-profit with 1,001-5,000 employees

Vertica is a scalable solution.

View full review »
it_user464571 - PeerSpot reviewer
Senior Data Warehouse Architect at a media company

We had an issue caused by adding nodes, but this error was caused by ourselves, as we didn’t use the proper process for adding nodes. That led to some problems that needed to be solved. Even though we did something bad, the instance was still working properly from an outside point of view.

View full review »
PI
Vertica Database Architect at a tech consulting company with 51-200 employees

Scalability is great if you size it correctly to start with. Resizing a cluster isn’t for the faint of heart. All the data needs to be redistributed across the cluster when the cluster size changes, and that can take a very long time, depending on how much data you’re storing.

View full review »
it_user110262 - PeerSpot reviewer
Architect with 501-1,000 employees

We haven’t yet scaled out our system. So far performance has been good (taking into consideration that delete strategy mentioned in the Areas for Improvement question).

View full review »
ERICK RAMIREZ - PeerSpot reviewer
CEO at Imexperts Labs

This is a scalable solution. 

View full review »
MW
Director - Big Data, IoT and Analytics at a tech services company with 11-50 employees

This is a scalable solution. For example, if we look at Uber drivers, they are able to monitor the position and availability of the drivers and match that against the number of customers for every customer and every driver worldwide globally.

They do a geospatial analysis and calculate their search pricing. They are defined by geographical boundaries, they are defined by where the people are and where the drivers are. This is done for every city in the world for every driver. That gives you an idea of the scale they are able to do in this particular use case.

This gives you the idea of the scale, the performance, and the ability to do analytics in the database. They do this so much more cost-effectively than they would on any other platform.

View full review »
it_user102651 - PeerSpot reviewer
Lead Software Engineer - Theatrical Global at a marketing services firm with 1,001-5,000 employees

With the Community Edition we are restricted to three nodes. We have a lot of enterprise clients who stress our cluster to its limits. The only advice I would give to new adopters is that if you want superior performance and reliability you are better off going all-in with the enterprise edition and a large number of nodes; assuming you have a lot of clients who run queries concurrently.

View full review »
it_user114084 - PeerSpot reviewer
Co-Founder at a tech services company

No scalability issues. Like I said, in its competitive set it is just faster, better, depending on how you use it, because it is columnar.

View full review »
it_user418314 - PeerSpot reviewer
Associate at a tech services company with 501-1,000 employees

We have had no issues scaling it for our needs.

View full review »
it_user450444 - PeerSpot reviewer
BI Architect / Software Engineer at a tech services company with 51-200 employees

Scalability is one of the huge strengths of this product, and scalable in a way, as I said before, that is native to how we do business.

View full review »
MW
Director - Big Data, IoT and Analytics at a tech services company with 11-50 employees

Vertica is massively scalable. My customers' workloads vary. While the number of users is not necessarily the ideal performance measure, the user bases range from a few dozen in smaller setups to thousands in the largest setups. And some of my customers have several hundred users on the platform concurrently.

View full review »
it_user70134 - PeerSpot reviewer
Senior business Intelligence consultant at Asociación SevillaUP

Our DB isin in the tens of Gigs, we did not need to scale yet.

View full review »
MunkhsaikhanBayar - PeerSpot reviewer
Project Lead - Digital Transformation Unit at Bodi Electronics LLC

This is a scalable solution. 

View full review »
JG
Creator and Manager of Intelligent Water Loss Management Models at Qintess

The solution has great scalability. We started with one terabyte of compressed data, this is a lot of data and we never had problems with the scalability. You can have hundreds of terabytes with the solution if you want, it all depends on your needs.

View full review »
it_user528873 - PeerSpot reviewer
Data Scientist at a media company with 501-1,000 employees

I have not encountered any scalability issues; I think it's scalable.

View full review »
it_user505299 - PeerSpot reviewer
Management Consultant at a computer software company with 51-200 employees
it_user471384 - PeerSpot reviewer
CIO at a tech services company with 1,001-5,000 employees

The reason we like Hadoop and others is because they scale up, pricing doesn't scale up at the same level. Vertica is a license per terabyte product. They do give you discounts the more volume you get, but it adds up over time fast. We could scale at a lower cost with than other solutions.

Scaling was a pain point. Getting recommendation on how to set it up ultimately to provide the best performance, how many notes, other things. We got different answers from them.

View full review »
it_user427470 - PeerSpot reviewer
Technical Team Lead, Business Intelligence at a tech company with 501-1,000 employees

We've had no issues scaling it.

View full review »
it_user515835 - PeerSpot reviewer
Solution Engineering and Arcitect - Big Data, Data Science and Cloud Computing at a tech services company with 1,001-5,000 employees

I have not encountered any scalability issues.

View full review »
it_user417525 - PeerSpot reviewer
Software Engineer at a marketing services firm with 51-200 employees

Scalability was a problem given we had to host the solution ourselves. It would be great to have a cloud-based solution around Vertica. Also, we found it difficult to modify and update our schema as we grew. Part of the problem may have been that when we first started using Vertica we were inexperienced.

View full review »
JS
Sr. SW Engineer - Databases with 201-500 employees

Suboptimal projection design causes queries to not scale linearly.

The metadata layer does not scale linearly.

Metadata for database files scale okay, but metadata related to tables/columns/sequences must be stored on all nodes.

View full review »
it_user431877 - PeerSpot reviewer
Consultant at a tech services company with 10,001+ employees

We have been able to scale it for our needs.

View full review »
it_user531828 - PeerSpot reviewer
Software and Data Architect at a computer software company with 1,001-5,000 employees
it_user504552 - PeerSpot reviewer
Sr. Developer, Big Data at a comms service provider with 51-200 employees
it_user624996 - PeerSpot reviewer
Architect at a comms service provider with 1,001-5,000 employees

We did not encounter hardly any scalability issues.

View full review »
it_user158742 - PeerSpot reviewer
Director of Software Development at a tech company with 501-1,000 employees

There have not been any scalability issues. We are able to support trillions of data elements by adding more servers.

View full review »
it_user505416 - PeerSpot reviewer
Database Admin at a tech services company with 1,001-5,000 employees
it_user505263 - PeerSpot reviewer
Principal Data Architect (BI) at a media company with 1,001-5,000 employees
it_user505182 - PeerSpot reviewer
Data Scientist at a tech services company with 501-1,000 employees
Ricardo Díaz - PeerSpot reviewer
COO at a tech services company with 11-50 employees
CK
Manager at Bizinfo Thailand

I have found the solution to be scalable.

View full review »
it_user692295 - PeerSpot reviewer
Staff Dev Lead - Analytics Data Storage at a tech services company with 1,001-5,000 employees

The default layout (all nodes running spread) introduces latencies in query planning when you reach about 60 nodes, in our experience. Switching to a large cluster (one control node per rack) would be advised, way before reaching the 128 nodes hard limit.

View full review »
it_user567630 - PeerSpot reviewer
Senior Vice President Data at Adform

Before using Vertica, we used to have problems scaling out because we increase our customer base significantly each year. We have more than 20.000 clients now. Since we implemented the Vertica solution, it is much less effort to maintain scalability.

View full review »
it_user505338 - PeerSpot reviewer
High FrequencyTrading Systems and Strategy Architect/Quant Trader at a financial services firm with 51-200 employees

We can scale a lot, wish it was a bit more affordable.

View full review »
it_user505098 - PeerSpot reviewer
Sr. DevOps Engineer, Adometry at a tech company with 10,001+ employees

Depends on the environment. Generally pretty good. If you have a large catalog, you can get timeouts adding nodes. Large catalog issues have been dealt with it recent releases so this should make scaling up even more robust.

View full review »
it_user505137 - PeerSpot reviewer
Owner at a tech vendor
it_user539496 - PeerSpot reviewer
Development Operations/SRE at a computer software company with 501-1,000 employees
it_user505863 - PeerSpot reviewer
Vertica DBA at a tech services company with 51-200 employees
it_user505317 - PeerSpot reviewer
DW Admin at a hospitality company with 1,001-5,000 employees
it_user433491 - PeerSpot reviewer
Cloud Architect, Oracle ACE, Oracle DBA at Pythian

There were no scalability issues.

View full review »
it_user533094 - PeerSpot reviewer
Lead Data Scientist Machine Learning at a financial services firm with 51-200 employees

No, scalability is also a strength of the solution.

View full review »
it_user848262 - PeerSpot reviewer
Hewlett Packard Enterprise Solution Architect at a tech services company with 11-50 employees

It has an elastic scalability solution.

View full review »
it_user464844 - PeerSpot reviewer
Big Data DBA & DevOps at a tech vendor with 51-200 employees

It is very easy to scale Vertica as you need.

View full review »
it_user703536 - PeerSpot reviewer
Technical Leader / Business Intelligence Consultant with 11-50 employees

No scalability issues.

View full review »
it_user505386 - PeerSpot reviewer
Senior Database Administrator; HP Vertica, MySQL, MSSQL, Cloud Ops at a tech vendor with 501-1,000 employees
it_user411165 - PeerSpot reviewer
Big Data, Analytics and Hadoop Expert, Vertica DBA (Technical Leader), Architecture Group at a tech vendor with 5,001-10,000 employees

There have been no issues scaling it for our needs.

View full review »
it_user467523 - PeerSpot reviewer
BI and Reporting Platform Teams and Tech leader at a computer software company with 1,001-5,000 employees

Rebalancing after adding nodes is an issue in terms of resources and especially locking of tables. It would be nice if this could be more transparent.

View full review »
it_user540294 - PeerSpot reviewer
Member of Technical Staff at a tech company with 1,001-5,000 employees

We did not encounter any issues with scalability.

View full review »
Buyer's Guide
Vertica
March 2024
Learn what your peers think about Vertica. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
767,847 professionals have used our research since 2012.