13 ms·
Postgres 10 added support logical replication. It makes horizontal scaling fairly painless.
by sgk284 9y ago
Postgres 10 added support logical replication. It makes horizontal scaling fairly painless.
- wutwutwutwut 9y agoUntil you need to reseed the original master, want to do quick rolling restarts or want any automation in automatic failover. PG has a long way to go. A
- manigandham 9y agoLogical replication by default doesn't even handle DDL statements so something as simple as adding a new column requires extra process. Postgres is probably the weakest of all relational databases when it comes to scalability, both vertical and horizontal.