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.

Buyer's Guide
VMware Tanzu Greenplum
April 2024
Learn what your peers think about VMware Tanzu Greenplum. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
769,976 professionals have used our research since 2012.

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 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
Vendor
​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
VMware Tanzu Greenplum
April 2024
Learn what your peers think about VMware Tanzu Greenplum. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
769,976 professionals have used our research since 2012.
it_user259983 - PeerSpot reviewer
Lead Consultant with 501-1,000 employees
Vendor
Session management needs improvement, but performs well with larger data volumes because it uses massively parallel processing.

What is most valuable?

The performance is the most valuable.

How has it helped my organization?

There is only a fraction of performance tuning that you need to be careful about, compared to Oracle DB.

What needs improvement?

Session management for client tools needs work.

For how long have I used the solution?

I've used it for nine months.

How are customer service and technical support?

Customer Service:

Nothing to complain about.

Technical Support:

Nothing to complain about.

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

Previously, there was Oracle database, and the EMC Greenplum database was used for better performance from larger data volumes because it uses massively parallel processing. This increased the performances multiple times while reducing time needed for optimization of database queries.

What about the implementation team?

We had a team from EMC, who had a very high level of expertise.

What other advice do I have?

It's a very good product for reducing the time and man power needed for database optimization for datawarehousing purposes.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
PeerSpot user
President of the Board at a tech services company with 51-200 employees
Real User
An excellent open-source solution with great analytical performance
Pros and Cons
  • "Scalability is simple because it's an MPP database. If you need more processing power or you need more storage, you just add a few more nodes in the cluster. It works on common commodity hardware. You can use any type of server. You don't need to have proprietary hardware. It's fairly flexible."
  • "Some integration with other platforms like design tools, and ETL development tools, that will enable some advanced functionality, like fully down processing, etc."

What is most valuable?

It's a good core database. Scalability and performance are very good. I also like the fact the solution is open-source, so you can use it free of charge.

What needs improvement?

Some integration with other platforms like design tools, and ETL development tools, that will enable some advanced functionality (like fully down processing, etc.) would be helpful in future releases. Also, if the solution could offer automated creation of DDL statements from power designers, for example, it would be very useful. 

For how long have I used the solution?

I've been using the solution for five years.

What do I think about the stability of the solution?

It's a software, and like any software, it has some bugs. However, you can add new features to improve it. Overall, our customers, who are big telcos, have been very satisfied with the platform and with its stability and performance

What do I think about the scalability of the solution?

Scalability is simple because it's an MPP database. If you need more processing power or you need more storage, you just add a few more nodes in the cluster. It works on common commodity hardware. You can use any type of server. You don't need to have proprietary hardware. It's fairly flexible.

The solution requires a minimum amount of downtime when scaling. You can even add additional nodes without any downtime at all. I'm not 100% sure, but I think you can just reconfigure it and the background processes, and Greenplum will do the redistribution of the data.

How are customer service and technical support?

Technical support is very good. The model they are using to fund the development of their open-source product is via revenue from support for enterprise customers, so they are very attentive when issues arise.

How was the initial setup?

The solution is very straightforward to set up and is also easy to administer and develop using other open-source tools.

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

It's open-source, so it's free to use.

What other advice do I have?

I'm a partner that works mainly with enterprises. Mostly the partners are big telcos and we deal with tens of terabytes of data.

MPP and columnar databases are the future of the analytical landscape. The era of appliances is over, so implementation of an MPP database on-premises or on the cloud is the way to go. Greenplum is definitely one of the leaders in this area.

I would rate the solution eight out of ten. If they improved the integration with other platforms in the landscape I would rate it higher. 

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 Greenplum Report and get advice and tips from experienced pros sharing their opinions.
Updated: April 2024
Product Categories
Data Warehouse
Buyer's Guide
Download our free VMware Tanzu Greenplum Report and get advice and tips from experienced pros sharing their opinions.