News for hackers. Stuff that matters.
Re:At 22 years old, Postgres might just be the most advanced... by TylerE on Wednesday December 05, 2018 @02:42PM (#18611726)
Scaling/replication is the usual thing. Postgres certainly has a better story here than it used to, but if you want to do serious scale replication it's very much in roll-your-own territory.

Like, imagine you have a few hundred terabytes of data you need to keep in-sync globally, between multiple datacenters, with many servers in each DC.

Re:At 22 years old, Postgres might just be the most advanced... by deepsun on Wednesday December 05, 2018 @02:53PM (#18611816)
I was under impression that only Spanner-like databases (CockroachDB and FaunaDB) are the only ones that can do cross-datacenter multi-row transactions at scale. Because they were designed exactly for this, otherwise tradeoffs taken are just too bad for the that use-case (e.g. too slow or too brittle in availability).

By cross-datacenter I mean datacenters far away from each other, in different geo regions.

Re:At 22 years old, Postgres might just be the most advanced... by madhadron on Wednesday December 05, 2018 @03:20PM (#18612111)
You can do single master, many read replicas, which works fine for many, many use cases.