Pg streaming replication is asynchronous by default and there are some big caveats besides performance when it comes to synchronous use cases, esp around automa

Pg streaming replication is asynchronous by default and there are some big caveats besides performance when it comes to synchronous use cases, esp around automatic fail-over / recovery. The pg/stolon FAQ hints at some of these issues: 1. https://github.com/sorintlab/stolon/blob/master/doc/faq.md#how-stolon-decide-which-standby-should-be-promoted-to-master https://github.com/sorintlab/stolon/blob/master/doc/faq.md#h...