Comment by ants_a
8 hours ago
Postgres setups are typically based on physical replication, which is not an option on MySQL. My testing shows the limit to be about 177k tps with each transaction consisting of 3 updates and 1 insert.
8 hours ago
Postgres setups are typically based on physical replication, which is not an option on MySQL. My testing shows the limit to be about 177k tps with each transaction consisting of 3 updates and 1 insert.
Be careful. During consulting I ran into similar magnitude of writes for a mostly CRUD workload.
They had huge problems with VACUUM at high tps. Basically the database never had space to breath and cleanup.