One of the most powerful parts about streaming replication in PostgreSQL is that one can set the replication mode on a per transaction basis.

I had no idea this was possible. It should be very useful when you have mix workloads on the same database.