Most developers use PostgreSQL every day. Very few can answer this question: what actually happens between the moment you hit Enter on a query and the moment you get a result back? Understanding ...
A developer disables fsync on a local or CI database to speed up tests — completely legitimate. PostgreSQL runs 3–5x faster in write-heavy test suites with it off. The config gets copied to staging.