sync() starves other reader/writers
sync() starves other reader/writers
Posted Mar 27, 2014 20:05 UTC (Thu) by dlang (guest, #313)In reply to: sync() starves other reader/writers by seanyoung
Parent article: PostgreSQL pain points
given that your transaction is likely to affect multiple database pages, #2 isn't viable, you can never guarantee that all or none of the transaction will be visible after a crash. That's why the databases do #1