5 ms·
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 transact
by ants_a 8mo 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 8mo agoBe 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.