> if none of those apply to you, CockroachDB is a better default.
Though it scales horizontally, you will need to throw at least 10x or more hardware at it to achieve the same throughput
Though it scales horizontally, you will need to throw at least 10x or more hardware at it to achieve the same throughput
I don’t have a like for like benchmark, but at least for writes - we’re running with 5 replicas of each range so that’s 5x the disk write i/o just from that.
Add in some network overhead and running raft etc, and you are going to be needing a lot more resources than for PG to maintain a similar throughput - but adding resources when you can scale horizontally is so much easier that the tradeoff is worth it in my experience.