Greenplum is based on Postgres is advanced fully featured open source data warehouse management system. Greenplum provides powerful processing of data varying across terabytes to petabytes.
Greenplum is fully equipped with powerful analytic tools which help in processing real time analytics data.
Greenplum database is more suitable for the environment where application using more joins and data is being modified very frequently.