News for hackers. Stuff that matters.
Re:RethinkDB versus PostgreSQL: my personal experience by phamilton on Friday February 10, 2017 @10:32AM (#13616028)
Horizontal scalability. Outgrowing a single master database (writes being bottlenecked, not reads) is really painful. You can engineer around it, but spinning up another master in a multimaster DB is a really quick and easy fix (once you have tooling built out it's a matter of minutes). Sharding your Postgres DB is not a quick and easy fix. It will likely take about a month to engineer around and perform the data migration, if not longer.
Re:RethinkDB versus PostgreSQL: my personal experience by floatboth on Friday February 10, 2017 @01:12PM (#13617512)
I've heard good things about Citus for horizontally scaling Postgres.
Re:RethinkDB versus PostgreSQL: my personal experience by phamilton on Friday February 10, 2017 @05:01PM (#13619291)
I've pretty much only heard about it in the context of OLAP. If your data model requires transactions, you're gonna have a hard time when you outgrow a database.