Pivotal Greenplum Review

It has HA built-in with mirroring and many other tuning features that make it highly configurable.


Valuable Features

  • Parallel Processing and Data Distribution based architecture.
  • HA built-in with mirroring.
  • Highly configurable and lots of tuning features.

Improvements to My Organization

  • This has helped us bring down our end-to-end EDW load time to 1/3 the time.
  • It has enabled faster and efficient data analysis.
  • Scalable environment without adding too much cost.

Room for Improvement

  • It needs a much more robust and user friendly monitoring and management front-end tool.
  • More stability and auto-recovery with the segments.
  • Report generations on system health and recommendations.

Use of Solution

I've used it for two years.

Deployment Issues

Up to now, we've had no issues with deployment.

Stability Issues

Up to now, we've had no issues with stability.

Scalability Issues

Up to now, we've had no issues with scalability.

Customer Service and Technical Support

The response is fairly good but would like more support from the R&D on more complex issues. Also, they need to ensure there are logs that can be used without causing any downtimes to the system for any case analysis.

Previous Solutions

It's a highly efficient and faster DB with lot of features at much less cost to that of other MPP DB’s evaluated.

Initial Setup

It was complex as we have to code convert everything into GP functions so as to best be able to use the GP parallel. Pushdown feature was not available via Informatica. The initial parameter setup took quite some time to test to get the sweet spot for performance.

Implementation Team

In-house with vendor support.

Other Advice

Make sure you have the designs, approaches and architecture in place before kicking of the implementation. Its best to have someone involved with prior migration experience.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
1 visitor found this review helpful
Add a Comment
Guest
Sign Up with Email