Live data from Hacker News

Pivotal Greenplum Database has been open sourced

github.com

1–10 of 52 posts

Re: Pivotal Greenplum Database has been open sourced

#7
"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.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?

Re: Pivotal Greenplum Database has been open sourced

#8

"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,…

> 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.

Re: Pivotal Greenplum Database has been open sourced

#9
This is exciting news. Greenplum's is one of the few instances of a Postgres-based MPP that I've had good experiences with.

The experiences and tuning in the query plan re-writer for MPP might be helpful in rolling in parallel operations support to the base. Not necessarily the "how" since the GP strategy won't necessarily mesh, but the "what".

Re: Pivotal Greenplum Database has been open sourced

#10
Edit: There's a shiny website too -- http://greenplum.org/

We (Pivotal, for whom I don't speak in any official capacity) have also opensourced Apache HAWQ (incubating)[1], which is an SQL front-end for Hadoop that was extracted from Greenplum, as well as Apache Geode (incubating)[2] which was based on GemFire.

This was part of a general announcement we made in February that our intention was to opensource our data products as it became possible to do so.

Incidentally, we are hiring engineers across our entire data suite, including PostgreSQL specialists. The Data division solves seriously heavyweight distributed problems. You can look up the listings on http://pivotal.io/careers, or if you like helping a fellow engineer collect a referral, email me: jchester@pivotal.io and I'll work out which office and division to send you to.

[1] http://hawq.incubator.apache.org/

[2] http://geode.incubator.apache.org/

Post reply on HN