ostgreSQL synchronous_commit options and Synchronous Standby Replication

One could be paying for something which is not really needed opting for undesirable levels of commit synchronization. A clear understanding of commit synchronization and choosing the right one for each transaction, session or user could result in very good saving and big difference in total throughput.