November 23, 2011

Hope for a new PostgreSQL era?

In a comedy of briefing errors, I’m not too clear on the details of my client salesforce.com’s new PostgreSQL-as-a-service offering, nor exactly on what my clients at VMware are bringing to the PostgreSQL virtualization/cloud party. That said:

So I think it would be cool if one or the other big company put significant wood behind the PostgreSQL arrow.

*While Vertica was originally released using little or no PostgreSQL code — reports varied — it featured high degrees of PostgreSQL compatibility.

Comments

8 Responses to “Hope for a new PostgreSQL era?”

  1. Jonatas on November 23rd, 2011 12:04 pm

    hear (on Brazil) many companies uses Postgres, including the brazilian government, the subway system… We have so many cases of success!! We are on the PostgreSQL era!!

  2. Oleg Bartunov on November 23rd, 2011 1:48 pm

    PostgreSQL is a candidate number 1 to
    National RDBMS in Russia !

  3. Robert Hodges on November 23rd, 2011 7:59 pm

    I have always assumed that the data warehouse forks used PostgreSQL at least in part because of the BSD licensing. You can fork PostgreSQL to create closed source products. By contrast the viable MySQL forks/clones (e.g., Percona or MariaDB) are open source under GPL V2 or a mix of BSD/GPL V2 like drizzle. I’m curious if any of your data warehousing contacts have commented on this aspect.

    Also, to be fair you would have to say that PostgreSQL has some catching up to do with MySQL/InnoDB in some areas. Logical replication and support for uncached writes to storage (O_DIRECT) rather than via the OS page cache come lightly to mind.

  4. Curt Monash on November 24th, 2011 7:50 am

    Robert,

    No doubt you are correct on the licensing.

  5. Scott Marlowe on December 7th, 2011 11:07 pm

    I would like some citations / reference for these points. Specifically when you state that “nor the PostgreSQL community leadership have covered themselves with stewardship glory.” what exactly do you mean? The current community has been making some very interesting progress on many fronts and the support I get from the mailing list has been nothing short of phenomenal. I’d like to know what you view as the shortcomings of the community.

  6. Chris Travers on December 8th, 2011 12:28 am

    One thing I’d suggest is that we already have a strong open source fork (not quite to 1.0) in the data warehouse space, namely Postgres-XC. This is a system that gives you high quality, transactional, distributed database similar to Teradata, and it’s at 0.9.6 at present.

  7. Chris Travers on December 8th, 2011 12:33 am

    Robert: no-logged tables are available in Pg 9.1, and you now have both synchronous and async replication built in.

  8. Strata Newsletter: January 19, 2012 - Strata on October 15th, 2012 11:08 am

    […] it has quietly moved to be a major backbone of database innovation: not least in big data products. Curt Monash’s article is an interesting catch-up on why PostgreSQL is important, and why it needs strong […]

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:

Login

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.