What is Greenplum database?.
Greenplum Database is a massively parallel processing (MPP) database server with an architecture specially designed to manage large-scale analytic data warehouses and business intelligence workloads.
Maintained by | License Type | Popular Examples | Support | Updates | Developer Skills |
---|---|---|---|---|---|
– | Apache 2 License | – | greenplum.org | – | UNIX or Linux / SQL |
Often Compared to | Testing | Accessibility | Maintained by | Repository |
---|---|---|---|---|
Postgresql, Hadoop | HammerDB | – | – | github.com/greenplum-db/gpdb |
Pros:
- Very fast for query processing.
Cons:
- Speed may suffer during large bulk operations or read queries.
- No support for delta backup, you can only backup a full table.
- No support for “point in time” recovery