RethinkDB versus PostgreSQL: my personal experience

Re:RethinkDB versus PostgreSQL: my personal experience by quizotic on Thursday February 09, 2017 @06:39PM (#13612074)

should also point out that Mongo is more than a jsonb store, and postgres is, at least currently, less than a distributed, "scale-out" database. Mongo supports problems that postgres cannot currently address. period. (and I'm a huge postgres fanboi)

[ Parent | on HN ]

Re:RethinkDB versus PostgreSQL: my personal experience by philliphaydon on Thursday February 09, 2017 @10:29PM (#13613012)

Could you share some of those problems? (genuinely interested)

[ Parent | on HN ]

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.

[ Parent | on HN ]

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.

[ Parent | on HN ]

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.

[ Parent | on HN ]