Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

PostgreSQL Outperforms MongoDB in New Round of Tests

blogs.enterprisedb.com

Post reply on HN
Print view View original

21–30 of 171 posts

Re: PostgreSQL Outperforms MongoDB in New Round of Tests

#21

Post by davidw »

Argorak wrote: post #16
threeseed wrote: post #11

Earlier quoted context omitted.

Except it doesn't. It just has a JSON data type. As does many other databases e.g. Oracle, Teradata. People are switching to MongoDB because the developer and deployment experience is so good.

Hate to say so, but many are switching to MongoDB because it's the current new kid on the block. I found that many companies have incredibly bad, not use-case driven reasons to pick their DB. Not that MongoDB is a bad database, but it has it's fair share of issues. Granted, this is the case for every database, but if you pick any database without being aware of those, you end up in a world of pain. (Context: I consul…

That was my only experience with MongoDB - "let's try this, for this experimental project, to see what it's like", without taking into account its characteristics.

After that the project grew, I was brought in and needed to do some reports, which were a huge pain in the ass without proper SQL and joins.

I don't intend to have anything to do with people using MongoDB unless they have a really, really good reason for doing so, and it's used alongside other databases.

Re: PostgreSQL Outperforms MongoDB in New Round of Tests

#24

Post by RyanZAG »

jedisct1 wrote: post #9

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.

Going off [1] it looks like TokuMX is a similar multiple faster than Mongo than Postgre is from Mongo, so I'd guess Postgre and Toku would be fairly similar speed wise. Obviously depending on your data and search patterns one may still be significantly faster than the other as the usual caveat.

[1] http://www.databasejournal.com/sqletc/tokumx-compared-to-mon...

Re: PostgreSQL Outperforms MongoDB in New Round of Tests

#26

Post by Xylakant »

threeseed wrote: post #11
wmf wrote: post #8

Earlier quoted context omitted.

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

Except it doesn't. It just has a JSON data type. As does many other databases e.g. Oracle, Teradata. People are switching to MongoDB because the developer and deployment experience is so good.

I maintain an environment that has both pg and mongodb. While pg was simple to install and to debug, mongo has given me just pains. I agree that MongoDBs developer experience is nice - download, run, develop, but from the OPS side, that looks totally different. PG is a bit the other way round.

The sad state of affairs however is that often developers choose which DB they'd like to work with and (Dev)OPS doesn't get a say in that.

Re: PostgreSQL Outperforms MongoDB in New Round of Tests

#27

Post by kristaps »

threeseed wrote: post #11
wmf wrote: post #8

Earlier quoted context omitted.

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

Except it doesn't. It just has a JSON data type. As does many other databases e.g. Oracle, Teradata. People are switching to MongoDB because the developer and deployment experience is so good.

I refuse to believe you speak from experience.

Re: PostgreSQL Outperforms MongoDB in New Round of Tests

#28

Post by kristaps »

threeseed wrote: post #11
wmf wrote: post #8

Earlier quoted context omitted.

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

Except it doesn't. It just has a JSON data type. As does many other databases e.g. Oracle, Teradata. People are switching to MongoDB because the developer and deployment experience is so good.

I refuse to believe you speak from experience.

Re: PostgreSQL Outperforms MongoDB in New Round of Tests

#29

Post by aikah »

threeseed wrote: post #11
wmf wrote: post #8

Earlier quoted context omitted.

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

Except it doesn't. It just has a JSON data type. As does many other databases e.g. Oracle, Teradata. People are switching to MongoDB because the developer and deployment experience is so good.

> People are switching to MongoDB because the developer and deployment experience is so good.

WAT? can you tell us more about your experience? according to mine ,developers are moving away "en masse" from Mongodb,because the experience was so bad.

Re: PostgreSQL Outperforms MongoDB in New Round of Tests

#30

Post by [deleted] »

jsemrau wrote: post #20
threeseed wrote: post #11

Earlier quoted context omitted.

Except it doesn't. It just has a JSON data type. As does many other databases e.g. Oracle, Teradata. People are switching to MongoDB because the developer and deployment experience is so good.

>because the developer and deployment experience is so good. That was ironic, right? http://php.net/manual/en/mongo.sqltomongo.php

[deleted]
Post reply on HN