PostgreSQL Outperforms MongoDB in New Round of Tests

#1

Post by wslh » Sat, Sep 27, 2014, 4:15 AM UTC

PostgreSQL Outperforms MongoDB in New Round of Tests
blogs.enterprisedb.com

Re: PostgreSQL Outperforms MongoDB in New Round of Tests

#2

Post by dang » Sat, Sep 27, 2014, 5:37 AM UTC

Url changed from http://developers-beta.slashdot.org/story/14/09/26/1330228/p..., which points to this.

Re: PostgreSQL Outperforms MongoDB in New Round of Tests

#3

Post by jvehent » Sat, Sep 27, 2014, 5:48 AM UTC

I have been using JSON types in postgres 9.3 for several weeks now. It's nice. It just works. I love being able to mix relational logic on static columns with undefined documents on dynamic columns, all in the same tables.

Re: PostgreSQL Outperforms MongoDB in New Round of Tests

#4

Post by xtrumanx » Sat, Sep 27, 2014, 5:54 AM UTC

Only problem I have with JSON on Postgres is you can't update a property of a JSON object like so:

    update table set jsonCol->propertyA = 42;

You need to write an extension for that. Easiest to do so using Python but sadly Heroku doesn't support python on postgres since its unsafe.

Re: PostgreSQL Outperforms MongoDB in New Round of Tests

#5

Post by dschiptsov » Sat, Sep 27, 2014, 6:21 AM UTC

Since when MongoDB is considered as a database comparable with PostgreSQL?)

Re: PostgreSQL Outperforms MongoDB in New Round of Tests

#6

Post by ranman » Sat, Sep 27, 2014, 6:21 AM UTC

Why does the graph read 2.4 when they say they're testing 2.6?

Re: PostgreSQL Outperforms MongoDB in New Round of Tests

#7

Post by Sanddancer » Sat, Sep 27, 2014, 6:25 AM UTC

dschiptsov wrote: post #5

Since when MongoDB is considered as a database comparable with PostgreSQL?)

It's a comparison on MongoDB's home turf, showing how well PostgreSQL works when used as a NoSQL document store.

Re: PostgreSQL Outperforms MongoDB in New Round of Tests

#8

Post by wmf » Sat, Sep 27, 2014, 6:25 AM UTC

dschiptsov wrote: post #5

Since when MongoDB is considered as a database comparable with PostgreSQL?)

That's not really relevant, since the point is that Postgres can do what MongoDB does but faster.

Re: PostgreSQL Outperforms MongoDB in New Round of Tests

#9

Post by jedisct1 » Sat, Sep 27, 2014, 6:35 AM UTC

How does it compare to TokuMX?

I am a huge fan of PostgreSQL, but in order to avoid having to rewrite an application designed for Mongo, I tried TokuMX and was pleasantly surprised by its performance.

Re: PostgreSQL Outperforms MongoDB in New Round of Tests

#10

Post by threeseed » Sat, Sep 27, 2014, 6:47 AM UTC

Will be great if PostgreSQL ends up as a storage engine option in MongoDB like InnoDB. Then you have the better engine of PostgreSQL with the superior clustering, sharding and end user experience of MongoDB.

That said these articles are pretty pointless. Performance isn't the reason companies are switching to MongoDB.