Try our new research platform with insights from 80,000+ expert users
reviewer1148196 - PeerSpot reviewer
Site Manager at a tech services company with 51-200 employees
Real User
Helpful for horizontal scaling, but the deployment process can be made easier
Pros and Cons
  • "The most valuable feature for us is horizontal scaling."
  • "I saw some limitation with respect to the column store, and removing this would be an improvement."

What is our primary use case?

The primary use of this solution is for horizontal scalability.

We have an on-premises deployment.

What is most valuable?

The most valuable feature for us is horizontal scaling.

What needs improvement?

The deployment process for this solution could be made easier.

I saw some limitation with respect to the column store, and removing this would be an improvement.

For how long have I used the solution?

We have been using this solution for about two months.
Buyer's Guide
VMware Tanzu Data Solutions
December 2024
Learn what your peers think about VMware Tanzu Data Solutions. Get advice and tips from experienced pros sharing their opinions. Updated: December 2024.
824,121 professionals have used our research since 2012.

What do I think about the stability of the solution?

This solution is stable enough. 

What do I think about the scalability of the solution?

We are not yet sure about scalability, but we will see in the future.

How are customer service and support?

We have not been in touch with technical support for this solution.

Which solution did I use previously and why did I switch?

We were using MySQL prior to this solution.

How was the initial setup?

The initial setup of this solution was not simple, but it was not too complex, either. I would say that it was of medium complexity.

Our deployment took approximately two days, although this was only a partial deployment. We have yet to add another node.

What about the implementation team?

We performed the deployment in-house.

What's my experience with pricing, setup cost, and licensing?

We are using the open-source version of this solution.

Which other solutions did I evaluate?

Prior to choosing this solution, we evaluated MySQL and PostgreSQL.

What other advice do I have?

I would rate this solution a seven out of ten.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user776835 - PeerSpot reviewer
Senior Data Warehouse Developer at a comms service provider with 51-200 employees
Vendor
Provides polymorphic storage and very fast query processing
Pros and Cons
  • "Very fast for query processing."
  • "It will be very useful if we could communicate with other database types from Greenplum (using a database link)."

What is our primary use case?

It is a very good appliance for data warehouse (DWH) usage.

What is most valuable?

  • Very fast for query processing
  • Parallel load
  • Polymorphic storage

How has it helped my organization?

Before we had Oracle Exadata, some queries would take more than 20 hours of execution. With Greenplum, it take a few minutes.

What needs improvement?

It will be very useful if we could communicate with other database types from Greenplum (using a database link).

For how long have I used the solution?

Four years.

What do I think about the stability of the solution?

No issues.

What do I think about the scalability of the solution?

No issues.

How are customer service and technical support?

Good. I would give their technical support a seven out of 10.

Which solution did I use previously and why did I switch?

Yes, Oracle Exadata. Performance was the main criteria for switching to Greenplum.

How was the initial setup?

It was a simple setup.

What's my experience with pricing, setup cost, and licensing?

It is the best product with best fit for price/performance customer objectives.

Which other solutions did I evaluate?

We evaluated Oracle technology that we used before.

What other advice do I have?

I encourage other customer to try Greenplum, specifically for DWH use. It is a very useful product.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
VMware Tanzu Data Solutions
December 2024
Learn what your peers think about VMware Tanzu Data Solutions. Get advice and tips from experienced pros sharing their opinions. Updated: December 2024.
824,121 professionals have used our research since 2012.
it_user589473 - PeerSpot reviewer
Full Stack Developer Intern at a tech vendor with 1,001-5,000 employees
Vendor
We used it to implement a three-tier structure and to decouple our front end from the back end.

What is most valuable?

Some valuable features of this product are:

  • Message queuing
  • Good support
  • Provided scalability and a distributed environment
  • Easy usability with NodeJS
  • Could easily withstand and pass stress/load testing with more than 10K API calls
  • Helped achieve a distributed environment and implement a 3-tier structure
  • Helped to develop a highly scalable system by decoupling front end and back end

How has it helped my organization?

We had a project where we had huge responses to APIs from the front-end and had to handle such large responses/requests without losing any of them. RabbitMQ efficiently handled this problem by providing message queuing and decoupling our front end and back end.

What needs improvement?

I would love to see better documentation/demo for few technologies. There is need for better stability in the Windows environment.

For how long have I used the solution?

I have used this product for around six months.

What do I think about the stability of the solution?

We encountered a few problems with Windows while clustering and hence we used Linux.

What do I think about the scalability of the solution?

We did not encounter any scalability issues.

How is customer service and technical support?

I would give the technical support a 7/10 rating.

How was the initial setup?

It involved more of research as how to use RabbitMQ. For clustering, it was little bit complex but I was able to follow the documentation provided.

Which other solutions did I evaluate?

We did not evaluate any other solution prior to this one.

What other advice do I have?

It gives product support with your technology.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user371766 - PeerSpot reviewer
Sr. Data Operation Engineer at a marketing services firm with 501-1,000 employees
Vendor
MPP architecture is important to process data in such volume.​ Better integration with big data tech stack is needed.

What is most valuable?

MPP (Massive Parallel Processing); processing large amount of data.

How has it helped my organization?

We process billions of rows of data every hour; MPP architecture is important to process data in such volume.

What needs improvement?

  • Better integration with big data tech stack
  • Scalability: for example, system schema (pg_catalog) is one bottleneck for scalability

For how long have I used the solution?

I've used it for four to five years.

What do I think about the scalability of the solution?

The system has some bottleneck, like system schema; some commands (batch loading) is bottlenecked by master DB architecture

How are customer service and technical support?

Customer Service:

It's very poor.

Technical Support:

It's very poor.

Which solution did I use previously and why did I switch?

Used Greenplum originally. We have evaluated other products; the final decision is based on ROI

How was the initial setup?

Products was installed by vendor; all ETL scripts and schema are designed and implemented in-house.

What about the implementation team?

The product was installed by vendor; all ETL scripts and schema are designed and implemented in-house.

What's my experience with pricing, setup cost, and licensing?

Greenplum has an open source version now.

What other advice do I have?

Scalability is one major concern; once data reach certain level; the performance is dropped and much more issues will be triggered, like disk error; out of memory; etc. Be sure that you proper scope your need (including growth) before the decision of system and its size.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user1256802 - PeerSpot reviewer
Consultant/Architect with 51-200 employees
Consultant
Feature-rich solution but the setup is complex
Pros and Cons
  • "Pivotal Greenplum's shared-nothing architecture."
  • "Initial setup is a little complex. It took around two weeks to deploy."

What is our primary use case?

Our primary use case is for telecom customers.

What is most valuable?

In terms of most valuable features, I'd say Pivotal Greenplum's shared-nothing architecture.

What needs improvement?

I'd like to see a bridge between Greenplum and Hadoop.

What do I think about the stability of the solution?

We didn't have any issues yet with stability.

What do I think about the scalability of the solution?

In terms of scalability, I just have one master and two segment hosts.

How was the initial setup?

Initial setup is a little complex. It took around two weeks to deploy.

What other advice do I have?

I prefer an open-source solution but Pivotal Greenplum is cheap and has many functionalities.

On a scale of 1 -10 I'd rate it a 6.

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Solutions Engineer at VST-ECS Philippines Inc.
Real User
Allows you to benefit from the contributions of a vibrant community of developers
Pros and Cons
  • "It's super easy to deploy and it also supports different languages and analytics."
  • "They should add more analytics. Their documentation could also be improved so that I don't have to bother my co-workers and tech support so often."

What is most valuable?

It's super easy to deploy and it also supports different languages and analytics.

What needs improvement?

As of now, I honestly don't see any room for improvement. I am very happy with this solution, It's helped me a lot.

They should add more analytics. Their documentation could also be improved so that I don't have to bother my coworkers and tech support so often. 

They should advertise more and make it easier for consumers to leave feedback. That way, customers could read the reviews and decide if it's the right solution for them and their needs.

For how long have I used the solution?

I have been using VMware Tanzu Greenplum for roughly one year.

What do I think about the scalability of the solution?

VMware Tanzu Greenplum is both scalable and stable.

How are customer service and technical support?

Their technical support is great.

How was the initial setup?

The initial setup is very easy. Deployment took us roughly one or two days.

What other advice do I have?

I would definitely recommend VMware Tanzu Greenplum. It's open-source and the support is great. It's also relatively cheap compared to similar solutions.

Overall, on a scale from one to ten, I would give this solution a rating of ten — I really like it.

Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
PeerSpot user
it_user374739 - PeerSpot reviewer
Data Warehouse Specialist at a comms service provider with 1,001-5,000 employees
Vendor
The most valuable features are MPP and that it's polymorphic.​ ​It doesn't work as efficiently as we'd like because it requires more segment node capacity than we currently have.

What is most valuable?

The most valuable features are MPP and that it's polymorphic.

How has it helped my organization?

We have a set of workflow flows that takes 10 hours in Oracle Exadata, now it takes 4 hours with EMC Greenplum.

What needs improvement?

It doesn't work as efficiently as we'd like because it requires more segment node capacity (size, RAM, CPU) than we currently have.

For how long have I used the solution?

I've used it since 2013.

What was my experience with deployment of the solution?

At the moment, we don't have any issues with deployment.

What do I think about the stability of the solution?

At the moment, we don't have any issues with stability.

What do I think about the scalability of the solution?

At the moment, we don't have any issues with scalability.

How are customer service and technical support?

Customer Service:

8/10

Technical Support:

8/10

Which solution did I use previously and why did I switch?

Yes, we have Oracle Exadata.

How was the initial setup?

The initial setup is straightforward. It was simple for our personnel to install on the Unix system and network.

What about the implementation team?


What was our ROI?

It's a good product when comparing the price to its functionalities.

What other advice do I have?

You should consider the capacity of your data before you buy it.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user371724 - PeerSpot reviewer
DB Manager at a marketing services firm with 501-1,000 employees
Real User
​The reports are running very fast, a matter of minutes instead of hours as it was previously.

What is most valuable?

The MPP – fast aggregation and that I still reuse the PL/SQL code.

How has it helped my organization?

The reports are running very fast, a matter of minutes instead of hours as it was previously.

What needs improvement?

It should support more feature that do exist on Postgres – like JSON datatype.

For how long have I used the solution?

I've used it for three years.

What was my experience with deployment of the solution?

Not more than any new DB – not something particular.

What do I think about the stability of the solution?

Not more than any new DB – not something particular.

What do I think about the scalability of the solution?

Not more than any new DB – not something particular.

How are customer service and technical support?

Customer Service:

It's good.

Technical Support:

It's good.

Which solution did I use previously and why did I switch?

I used Oracle Enterprise edition – moving to Greenplum due to the MPP (it’s like Map-Reduce). I prefer a SQL solution rather Hadoop or whatever – especially if you’re moving from RDBMS. Now I’m also using Amazon Redshift from the same reason and also we don’t need to manage any server, it’s only a service and this is our best option especially because we’re already using Amazon.

How was the initial setup?

It's straightforward.

What about the implementation team?

In-house.

What other advice do I have?

Read the documentation and always perform tests.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
Download our free VMware Tanzu Data Solutions Report and get advice and tips from experienced pros sharing their opinions.
Updated: December 2024
Buyer's Guide
Download our free VMware Tanzu Data Solutions Report and get advice and tips from experienced pros sharing their opinions.