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

Synchronous replication exists to avoid more of the transactions committed problem.

Thing is DB work is all about tradeoffs, so you'll never be free of them.

As the parent explained, PostgreSQL actually lets you make a very good trade: you get full cached level performance but lose only a couple of transactions at most, instead of data corruption. If that's not ok for you, the leash can be tightened to lose nothing, but then your hardware had better keep up with your platform.



Consider applying for YC's Winter 2026 batch! Applications are open till Nov 10

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

Search: