Hacker News Reader

HNHacker News

Top New Best Ask Show Jobs

Comment by dr_faustus | Hacker News Reader

Parent Full thread

dr_faustus·

I'd be more interested, why you moved from Mongo to Postgres.

View on HN

Probably because postgres can do what mongo does just as well, and is a full RDBMS.

Take a look at postgres hstore with a gin index.

hstore isn't really as flexible as a Mongo document, given that both keys and values must be strings, and you can't query into a document nested inside an hstore value.

Now, with the jsonb support coming in 9.4, PG gets pretty much everything I once liked Mongo for.

http://www.postgresql.org/message-id/E1WRpmB-0002et-MT@gemul...

Look at performance numbers:

http://thebuild.com/presentations/pg-as-nosql-pgday-fosdem-2...

Furthermore, consider that PG is pretty much an amazing RDBMS in addition to having a good document story.

If numbers are the deciding factor for anyone, have a look at TokuMX which I believe has much better performance and storage characteristics compared to plain Mongo.

http://www.tokutek.com/products/tokumx-for-mongodb/

I don't know about the author, but I've found MongoDB to have very poor performance compared to Postgres.

To answer your question - we were rebuilding the app and in the process moving from Rackspace into AWS. We wanted to use as many amazon managed services as possible since we don't have a huge team. PostgreSQL seemed like a nice managed solution that would give us plenty of room to scale. The ACID guarantees aren't too bad either.

Reply on news.ycombinator.com