Postgres setups are typically based on physical replication, which is not an opt... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		ants_a 12 days ago \| parent \| context \| favorite \| on: Scaling PostgreSQL to power 800M ChatGPT users 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 12 days 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.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact