top | item 46732479 (no title) ants_a | 1 month 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. discuss order hn newest hu3|1 month ago 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.
hu3|1 month ago 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.
hu3|1 month ago
They had huge problems with VACUUM at high tps. Basically the database never had space to breath and cleanup.