| ▲ | ants_a 4 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. | ||
| ▲ | hu3 28 minutes ago | parent [-] | |
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. | ||