difference between open source gpdb and commercial pivotal gpdb? difference between 5.8 and 6.0.0?

[ben]

Hi guys, I'm trying to use gpdb as data warehouse tool, could anyone tell me what are the differences between the open sourced gpdb and the commercial pivotal gpdb?

I also wonder about the differences between gpdb 6.0.0-alpha and  gpdb 5.8 which according to what I saw in GitHub was released 7 days ago. when is the planned release

date for stable 6.0.0 and will it include some significant improvements or features? Thanks.

/Ben

[Simon Gao]

you can see the difference in release notes:

http://gpdb.docs.pivotal.io/580/relnotes/GPDB_580_README.html#topic_uvz_dfc_cz

--
You received this message because you are subscribed to the Google Groups "Greenplum Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to gpdb-users+unsubscribe@greenplum.org.
To post to this group, send email to gpdb-...@greenplum.org.
Visit this group at https://groups.google.com/a/greenplum.org/group/gpdb-users/.
For more options, visit https://groups.google.com/a/greenplum.org/d/optout.

[Robert Eckhardt]

On Thu, May 10, 2018 at 10:37 PM, ben <batm...@gmail.com> wrote:
> Hi guys, I'm trying to use gpdb as data warehouse tool, could anyone tell me
> what are the differences between the open sourced gpdb and the commercial
> pivotal gpdb?

Currently the primary difference with the server is that the Pivotal
version has the option of Quicklz compression which does not exist in
the open source repo for licensing reasons.

The real difference is that with the enterprise version you also get
access to a bunch of other analytical tools that work with the
database such as Command Center (management and monitoring tool),
gptext (GPDB and Solr integration) connectors to Gemfire, informatica,
and I think a few other things. Also the Enterprise offering comes
with a full support offering.

> I also wonder about the differences between gpdb 6.0.0-alpha and gpdb 5.8
> which according to what I saw in GitHub was released 7 days ago. when is the
> planned release
> date for stable 6.0.0 and will it include some significant improvements or
> features? Thanks.

6.0.0-alpha (we should really make that -dev rather than -alpha) is
the current development branch, if you are interested in working on
Greenplum or playing with certain features you are welcome to try it
HOWEVER, we make no promises wrt being able to upgrade from it nor is
there any support for it.

currently we aren't publishing a release date for 6. As far as
development is concerned I hope that you will consider the changes as
a significant improvement. We are working in earnest to catch up to a
more modern Postgres. The current 5.x stable branch is based on
Postgres 8.3, currently Master (6.0.0-alpha) is based on Postgres 9.0
and we expect to have Postgres version 9.1 merged in by next week. We
are going to continue to work on merging those features as well as
many others to improve concurrency, mixed workloads, general
performance etc. throughout the development process.

If you are wanting to try Greenplum and think that you might be using
it for a while I'd recommend using the 5.8 tag. That is the most
current release of the stable branch.

Good luck and thanks for reaching out.

-- Rob

>
> /Ben
>
> --
> You received this message because you are subscribed to the Google Groups
> "Greenplum Users" group.
> To unsubscribe from this group and stop receiving emails from it, send an

> email to gpdb-users+...@greenplum.org.

[ben]

thanks simon, I got it.

On Friday, May 11, 2018 at 10:52:34 AM UTC+8, SIMON GAO wrote:

you can see the difference in release notes:

http://gpdb.docs.pivotal.io/580/relnotes/GPDB_580_README.html#topic_uvz_dfc_cz

On Fri, May 11, 2018 at 10:37 AM, ben <batm...@gmail.com> wrote:

Hi guys, I'm trying to use gpdb as data warehouse tool, could anyone tell me what are the differences between the open sourced gpdb and the commercial pivotal gpdb?

I also wonder about the differences between gpdb 6.0.0-alpha and  gpdb 5.8 which according to what I saw in GitHub was released 7 days ago. when is the planned release

date for stable 6.0.0 and will it include some significant improvements or features? Thanks.

/Ben

--
You received this message because you are subscribed to the Google Groups "Greenplum Users" group.

To unsubscribe from this group and stop receiving emails from it, send an email to gpdb-users+...@greenplum.org.

[ben]

Thanks, rob. Currently I'm trying to find a stable GP version to use for my data warehouse case, if 6.0.0 rolls out later very soon with update on pq, I will switch to that.So currently I will go with 5.8

By the way, if I choose to use the open sourced GP(install GP by building from source tag 5.8), are those GP utilities(GPCC, workload manager, gptext, etc) separately provided for download and install?

I'm not aware of the differences between the open sourced GP and the commercial counterpart on a source code basis, what I really want to achieve is I could install GP and have it up and running and

when something goes wrong, I could possibly dive into the source code trying to find out the reason and solution. If the commercial binary maps exactly to the open sourced one except QuickLz due

to license problem(without any bug fixes or feature enhancements based on the open sourced one), then I will go with the commercial one. Thanks.

/Ben

[Robert Eckhardt]

On Thu, May 10, 2018 at 11:25 PM, ben <batm...@gmail.com> wrote:
> Thanks, rob. Currently I'm trying to find a stable GP version to use for my
> data warehouse case, if 6.0.0 rolls out later very soon with update on pq, I
> will switch to that.So currently I will go with 5.8
> By the way, if I choose to use the open sourced GP(install GP by building
> from source tag 5.8), are those GP utilities(GPCC, workload manager, gptext,
> etc) separately provided for download and install?

These are only available with the licensed product from Pivotal. If
you buy another distribution there will probably be equivelant
licensed products for them.

> I'm not aware of the differences between the open sourced GP and the
> commercial counterpart on a source code basis, what I really want to achieve
> is I could install GP and have it up and running and
> when something goes wrong, I could possibly dive into the source code trying
> to find out the reason and solution. If the commercial binary maps exactly
> to the open sourced one except QuickLz due
> to license problem(without any bug fixes or feature enhancements based on
> the open sourced one), then I will go with the commercial one. Thanks.

Diving into the code to look for bugs on your own is absolutely
possible and encouraged. If you find a bug or want to submit a
feature, all development goes through the master branch (6.0.0-alpha).
After it is accepted there backporting for minimally invasive things
can be done.

-- Rob