Postgres Pro
Downloads
Home   >   mailing lists

Re: SI messages sent when excuting ROLLBACK PREPARED command - Mailing list pgsql-hackers

From Tom Lane
Subject Re: SI messages sent when excuting ROLLBACK PREPARED command
Date
Msg-id 3520606.1626284171@sss.pgh.pa.us
Whole thread Raw
In response to SI messages sent when excuting ROLLBACK PREPARED command  ("liuhuailing@fujitsu.com" <liuhuailing@fujitsu.com>)
Responses RE: SI messages sent when excuting ROLLBACK PREPARED command
List pgsql-hackers
Tree view 
"liuhuailing@fujitsu.com" <liuhuailing@fujitsu.com> writes:
> So, I think we needn't send SI messags when rollbacking the two-phase transaction.
> Or Does it has something special because of two-phase transaction?

Hmmm, yeah, I think you're right.  It probably doesn't make a big
difference in the real world --- anyone who's dependent on the
performance of 2PC rollbaxks is Doing It Wrong.  But we'd have
already done LocalExecuteInvalidationMessage when getting out of
the prepared transaction, so no other SI invals should be needed.

            regards, tom lane

pgsql-hackers by date:

Previous
From: "Euler Taveira"
Date:
Subject: Re: row filtering for logical replication
Next
From: Ranier Vilela
Date:
Subject: Re: [PATCH] Use optimized single-datum tuplesort in ExecSort