3 ms·
WAL2 + BEGIN CONCURRENT ...to pretty much eliminate write contention. I know, it sucks these aren't built in yet. Also if we got some sort of router + map red
by geenat 3y ago
WAL2 + BEGIN CONCURRENT
...to pretty much eliminate write contention. I know, it sucks these aren't built in yet.
Also if we got some sort of router + map reduce helper (Vitess, Citus -like) it'd make massively distributed SQLite a lot more viable. Setups that don't hammer a single master would make all the difference.
Postgres' main disadvantage at scale is all the additional machinery required (backups, failover, proxy, no DDL replication with built-in logical replication .... UGH!!), even when you're using Citus. Feels like it forces you into k8s with the amount of orchestration you need to run.
- raggi 3y agothis does not eliminate write contention, it just moves a bunch of the problem into the application as now you have to resolve conflicts yourself