On 7/23/21, 4:23 AM, "Laurenz Albe" <laurenz.a...@cybertec.at> wrote: > But that would mean that changes ostensibly rolled back (because the > cancel request succeeded) will later turn out to be committed after all, > just like it is now (only later). Where is the advantage?
The advantage is that I can cancel waits for synchronous replication without risking data loss. The transactions would still be marked in- progress until we get the proper acknowledgement from the standbys. > Besides, there is no room for another transaction status in the > commit log. Right. Like the existing synchronous replication functionality, the commit log would be updated, but the transactions would still appear to be in-progress. Today, this is done via the procarray. Nathan