3 ms·
"Greenplum Database is based on PostgreSQL 8.2 with a few features added in from the 8.3 release. To support the distributed nature and typical workload of a Gr
by djokkataja 11y ago
"Greenplum Database is based on PostgreSQL 8.2 with a few features added in from the 8.3 release. To support the distributed nature and typical workload of a Greenplum Database system, some SQL commands have been added or modified, and there are a few PostgreSQL features that are not supported. Greenplum has also added features not found in PostgreSQL, such as physical data distribution, parallel query optimization, external tables, resource queues for workload management and enhanced table partitioning."
http://gpdb.docs.pivotal.io/4360/ref_guide/feature_summary.html#topic8 http://gpdb.docs.pivotal.io/4360/ref_guide/feature_summary.h...
Are there plans to eventually have full feature parity with ongoing PostgreSQL development (as in adding features from versions of PostgreSQL newer than 8.2), or is Greenplum going to mostly be taking its own trajectory?
- jacques_chester 11y ago> Are there plans to eventually have full feature parity with ongoing PostgreSQL development, or is Greenplum going to mostly be taking its own trajectory? I asked about this today while I was at work. The gist was: it will depend on a lot of factors, so it'd be unwise to nail any documents to any doors. But watch this space for further developments. In the mean time, Greenplum speaks the PostgreSQL wire protocol. All the tools that can speak to PostgreSQL can speak seamlessly to Greenplum. Disclaimer: While I work for Pivotal, I work in Pivotal Labs. I'm just an engineer and I don't have any input into product direction for our data products, which is done in another division. If pain persists, consult your doctor.