On Fri, Dec 20, 2019 at 03:07:26PM +0500, Andrey Borodin wrote: >> Sending a cancellation is currently the only way to resume after >> disabling synchronous replication. Some HA solutions (e.g. >> pg_auto_failover) rely on this behaviour. Would it be worth checking >> whether synchronous replication is still required? > > I think changing synchronous_standby_names to some available > standbys will resume all backends waiting for synchronous > replication. Do we need to check necessity of synchronous > replication in any other case?
Yeah, I am not on board with the concept of this thread. Depending on your HA configuration you can also reset synchronous_standby_names after a certain small-ish threshold has been reached in WAL to get at the same result by disabling synchronous replication, though your cluster cannot perform safely a failover so you need to keep track of that state. Something which would be useful is to improve some cases where you still want to use synchronous replication by switching to a different standby. I recall that sometimes that can be rather slow.. -- Michael
signature.asc
Description: PGP signature
