> I have measured a planned switchover on a lightly loaded system (100tx/s) at 500ms from commit to commit. What does that switchover look like? You have serv

> I have measured a planned switchover on a lightly loaded system (100tx/s) at 500ms from commit to commit. What does that switchover look like? You have services that resolve the database DNS on startup and create a connection pool. While they are doing 100tx/s, how do you get them pointed to another instance without forcing them to restart? Also, how exactly is a Postgres commit streamed to a DR instance? I'm not interested in all of the possible configurations of master/slaver as much as I am just trying to understand... you've got a hot master receiving 100tx/s... what is mirroring the commit log / write ahead log to the DR master?