Just as fast (and that means pretty fast). Comparing to MongoDB might not make s...

wulczer on March 14, 2012 | parent | context | favorite | on: NoSQL with Postgres - Using Hstore in Rails

Just as fast (and that means pretty fast). Comparing to MongoDB might not make sense, if you're running it with no fsyncs (I don't know much about MongoDB, so maybe it is possible to make it fsync data).

There was a good talk about using Postgres as a key-value store at PGcon 2010, see http://www.pgcon.org/2010/schedule/events/219.en.html and http://www.scribd.com/gavinmroy/d/31669670-PostgreSQL-and-No... (especially the classic photo of DBAs running with scissors)

fduran on March 14, 2012 [–]

MongoDB makes a full flush by default every 30 seconds, it can be forced with the fsync command http://www.mongodb.org/display/DOCS/fsync+Command#fsyncComma...