October 19, 2009

Greenplum Single-Node Edition — sometimes free is a real cool price

Greenplum is announcing today that you can run Greenplum software on a single 8-core commodity server, free. First and foremost, that’s a strong statement that Greenplum wants enterprises to pay it for Greenplum’s parallelization/”private cloud” capabilities. Second, it may be an attractive gift to a variety of folks who want to extract insight from terabyte-scale databases of various kinds.

Greenplum Single-Node Edition:

For those who want free, terabyte-scale data warehousing software, Greenplum Single-Node Edition may be quite appealing, considering that the main available alternatives are:

For example, comparing PostgreSQL-based Greenplum with PostgreSQL itself, Greenplum offers:

Greenplum would surely also argue that its software is superior to PostgreSQL in parallel load, compression, MapReduce integration, and general fit-and-finish. I imagine that in some (perhaps not all) cases it would be right. PostgreSQL’s main technical advantages over Greenplum would probably lie in the area of datatype extensibility.

The main target users for Greenplum’s Single-Node Edition are obviously individual enterprise power users or very small analytic teams. I.e., it’s people with a data mart need that a central data warehouse isn’t meeting. Potential benefits to Greenplum include:

In addition, I see free Greenplum as a charity offering that could be appealing to scientists who face PostgreSQL performance limitations.

Related links


13 Responses to “Greenplum Single-Node Edition — sometimes free is a real cool price”

  1. Guillaume Theoret on October 19th, 2009 10:38 am

    Wow, that’s very interesting. I’m definitely going to give this a test run to see how it matches up against LucidDB.

  2. Jerome Pineau on October 19th, 2009 11:31 am

    I think InfoBright’s ICE version (if I recall the name correctly, the freebie version) is not really an option without any DML right?

  3. Bob Zurek on October 19th, 2009 3:04 pm

    You can find out more about Infobright Community Edition here:

    and information about our Enterprise Edition here:

  4. Todd Fin on October 19th, 2009 8:12 pm

    Don’t believe such a move can provide a big value. How this is different from just running PostgreSQL on the single server for free? Also who is the competitor greenplum is going to Deprive? Are you pointing to EnterpriseDB?

  5. Ben Werther on October 20th, 2009 12:44 am

    There’s a world of difference between running Greenplum and vanilla PostgreSQL for analytical queries. PostgreSQL is a great database, but on an 8 core box, each PostgreSQL query will only consume a single core and use 1/8th of the box. Greenplum will parallelize the query across all 8 cores, just like it can parallelize queries with linear scalability across many 100s of cores with the MPP edition.

  6. keru on October 20th, 2009 4:10 am

    As i posted on the greenplum forum : it’s GREAT for learning and evaluation purpose.

    As a DBA, i highly appreciate the 900+ pages greenplum documentation. But it’s even better when you can *use* the software related to the documentation 🙂

    And there is a LOT of difference between greenplum and postgresql (just read the first few page about SQL conformance of greenplum).

    Running greenplum on a single octocore node can be good… as long as you’re not IOBound 🙂

  7. Ruhal on October 20th, 2009 3:38 pm

    Unlike infobright there is a large user community providing production like scripts for Greenplum at http://www.gpdba.com.

  8. Paul Johnson on October 20th, 2009 5:51 pm

    Having been a Netezza PS partner, and having worked for Dataupia, I know how much work goes into making Postgres suitable for ‘big data’ use. There are real Greenplum differentiators in there when compared to Postgres (see Curt’s article).

    This is a very smart move by Greenplum from my perspective. The ability to scale-out from SMP to MPP when/if the need arises is very powerful, and not something many companies can offer.

  9. BI-Quotient » Blog Archive » Data warehousing for free! Terabyte sized data warehouse and business intelligence without license costs on October 26th, 2009 12:38 pm

    […] why are they giving away data warehouses for free? In another article, Curt Monash gives the following […]

  10. Quick news, links, comments, etc. | DBMS2 -- DataBase Management System Services on March 27th, 2010 1:00 am

    […] indeed often steer clients away from open source. For marketing purposes, I do feel that sometimes free can be a real cool price; but open source is not the only way to be […]

  11. Story of an analytic DBMS evaluation | DBMS2 -- DataBase Management System Services on April 16th, 2010 11:03 pm

    […] contact continues to be interested in all things Greenplum, and has recommended Greenplum Single-Node Edition to his analyst colleagues. Categories: Analytic technologies, Benchmarks and POCs, Buying […]

  12. Gartner 2009/2010 Data Warehouse Magic Quadrant comments | DBMS 2 : DataBase Management System Services on February 9th, 2011 4:47 am

    […] that’s a defensible claim — but it’s pretty irrelevant in a world where Greenplum Single-Node Edition can be had for free. It also waves away all the data mart use cases in which Infobright Community […]

  13. Data aggregation mongodb vs mysql – oraerr.com on July 24th, 2019 5:11 am

    […] You could also try the free single node edition of Greenplum: http://www.greenplum.com/products/single-node/ and http://www.dbms2.com/2009/10/19/greenplum-free-single-node-edition/ […]

Leave a Reply

Feed: DBMS (database management system), DW (data warehousing), BI (business intelligence), and analytics technology Subscribe to the Monash Research feed via RSS or email:


Search our blogs and white papers

Monash Research blogs

User consulting

Building a short list? Refining your strategic plan? We can help.

Vendor advisory

We tell vendors what's happening -- and, more important, what they should do about it.

Monash Research highlights

Learn about white papers, webcasts, and blog highlights, by RSS or email.