5 ms·

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

• fein 12y ago
  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.
  • deleted 12y ago
    [deleted]
  • bjt 12y ago
    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@gemulon.postgresql.org http://www.postgresql.org/message-id/E1WRpmB-0002et-MT@gemul...
• astine 12y ago
  I don't know about the author, but I've found MongoDB to have very poor performance compared to Postgres.
• angersock 12y ago
  Look at performance numbers: http://thebuild.com/presentations/pg-as-nosql-pgday-fosdem-2013.pdf 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.
  • ericingram 12y ago
    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/ http://www.tokutek.com/products/tokumx-for-mongodb/
• zenogais 12y ago
  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.