It is most modern and powerful DB build Review collected by and hosted on G2.com.
It's one of the most modern and powerful open source DB built for modern analytics using AI. The Database is built on already popular Postgres DB architecture which is a proven technology. Green plumb provides the unique cost-based query optimizer which helps to query large amounts of data and still pay less. This also does not degrade the DB performance even while dealing with petabytes of data. It's easy to deploy and maintain. Greenplum also provides AI features that collaborate with the analytics and operational workload features. Review collected by and hosted on G2.com.
1)UI and scripting options for greennplum.
2) Greenplum command center and alert with out of memory, max connections and segment failure helps the Dba to solve the issues quickly. Review collected by and hosted on G2.com.
Some inbuilt maintenance like vaccum should be there. And some new issues comes up after upgrade so more testing from pivotal is required. Review collected by and hosted on G2.com.
Greenplum is a good option to have, but till now, I have not seen significant market depth in its usage. Its capabilities are excellent. Review collected by and hosted on G2.com.
While it has great potential, there are other players which are far easier to use and have more acceptance. Review collected by and hosted on G2.com.
- PostgreSQL Compatibility
- Versatile plugins
- Versatile support for json handling and GIS
- Easy of use
- Easy of integration with external data source Review collected by and hosted on G2.com.
- Performance isn't good for extensive datasets processing (e.g. query, join...)
- Performance tuning is hard
- Adding new data node is not easy
- Concurrency processing isn't good enough
- No support for columnar mode query Review collected by and hosted on G2.com.
Ease of use, Ease of integration, deployment models, visualization, reporting, dashboarding Review collected by and hosted on G2.com.
There is nothing that I dislike about the product Review collected by and hosted on G2.com.
I like how I can improve my performance in big tables using the MPP architecture that Greenplum gives me Review collected by and hosted on G2.com.
The daily maintenance is usually a problem, if we have a big table and a lot of users are using this table Review collected by and hosted on G2.com.
Mirroring concept , expanding the nodes without downtime and performance is high Review collected by and hosted on G2.com.
Sometimes GP Optimizer will not work as expected .. Review collected by and hosted on G2.com.
1. The support for Massive parallel processing that GP offers.
2. Faster query executions - We execute many (100s) of queries on a daily basis and at the same time, the results come back in seconds.
3. Resource management
4. GrrenPlum Support - If we face any issues, the support team is there to help us out.
5. SQL like syntax. Review collected by and hosted on G2.com.
A few times we have noticed that the segments go down, but they usually come up in seconds. Review collected by and hosted on G2.com.