I find myself discussing and explaining sychronous_commit with many PostgreSQL users, especially with novice users. So, I thought of noting down all the key points as a blog post which will be useful for more users. Recently I got an opportunity to talk about some related topics in our PostgreSQL Percona Tech Days.
What Is sychronous_commit All About?
This is the parameter by which we can decide when a transaction-commit can be acknowledged back to the client as successful.