Slashdot Mirror

← Back to Stories (view on slashdot.org)

New PostgreSQL Guns For NoSQL Market

Posted by samzenpus on from the coming-for-you dept.

angry tapir (1463043) writes "Embracing the widely used JSON data-exchange format, the new version of the PostgreSQL open-source database takes aim at the growing NoSQL market of nonrelational data stores, notably the popular MongoDB. The first beta version of PostgreSQL 9.4, released Thursday, includes a number of new features that address the rapidly growing market for Web applications, many of which require fast storage and retrieval of large amounts of user data."

1 of 162 comments (clear)

  1. Re:How about Parallel Query Execution? by Anonymous Coward · · Score: 0, Troll

    PostgreSQL has no built-in parallelism. Partitioning is a joke, which doesn't support global primary keys or even global indexes and there are no hints, so if your model becomes too complex for the optimizer, you have to start all over again. In other words, PostgreSQL is a bad joke, meant to sell commercial variants like EnterpriseDB, which does have all of the above, Greenplum, Netezza, Vertica or VoltDB. PostgreSQL is a bait and switch DB which is not worth serious consideration. Yes, it is free but if somethin serious is needed, you need commercial databases like SQL Server, Oracle or DB2, all of which have decent partitioning, built-in parallelism, optimizer hints and all which can run circles around PostgreSQL.