[sgarland]

> Distributed databases reduce a lot of the operational complexity

That’s a new one to me; never have I ever heard someone claim that making a system distributed reduces complexity.

I’ve operated EDB’s Distributed Postgres at a decent scale (< 100 TB of unique data); in no way did it enable reduced complexity. For the devs, maybe – “chuck whatever data you want wherever you want, it’ll show up.” But for Ops? Absolutely not, it was a nightmare.

[std_reply]

I’m contrasting a single node database with bolted on replication vs a distributed SQL database that gives strong consistency out of the box.

[std_reply]

EDB Distributed Postgres under the hood is a single node database with bolted on replication.