Hi, On 2022-01-06 23:24:40 -0800, Jeff Davis wrote: > It feels like the sync quorum should always be ahead of the async > replicas. Unless I'm missing a use case, or there is some kind of > performance gotcha.
I don't see how it can *not* cause a major performance / latency gotcha. You're deliberately delaying replication after all? Synchronous replication doesn't guarantee *anything* about the ability for to fail over for other replicas. Nor would it after what's proposed here - another sync replica would still not be guaranteed to be able to follow the newly promoted primary. To me this just sounds like trying to shoehorn something into syncrep that it's not made for. Greetings, Andres Freund