3 ms·
They both have replication, which allows them to be multi-node.
by pbowyer 1y ago
They both have replication, which allows them to be multi-node.
- ViewTrick1002 1y agoWith the bounds capped by a single writer. Unless you can shard the data and create a distributed database with manual sharding. But yes. Postgres remains an amazing choice, especially with modern hardware, until you also have the money available to tackle said write throughput issue.
- sgt 1y agoI think the point is that sharding won't really help that much since transactions will happen across all or most shards, and then you have certain accounts that will be more active than others.
- samlambert 1y agoif your sharding schema is designed properly you will avoid cross shard transactions.
- sgt 1y agoHow so? Any account may transact with any other account - regardless which shard it resides in.
- big_hacker 1y agoTigerBeetle doesn't shard either.
- redwood 1y agoGood catch.
- jorangreef 1y agoYes, sharding would kill performance under contention, which characterizes many OLTP workloads (e.g. top ten bestseller list on Black Friday, super stocks like NVIDIA, the big 4 banks on a switch, PhonePe/Google Pay on UPI etc)
- menaerus 1y agoSharding is if anything a way to reduce the contention.
- jorangreef 1y agoTransactions typically need to hit the same set of house accounts. For example, fee accounts, omnibus accounts etc. Or a central bank switch may only have 4 major banks. Or a system like UPI may have 85% of transactions flowing through 2 hubs. Say 50% through PhonePe. And say 35% through Google Pay.