Robert Treat <xzilla@users.sourceforge.net> writes:
> On Sunday 16 March 2008 22:18, Tom Lane wrote:
>> Fix TransactionIdIsCurrentTransactionId() to use binary search instead of
>> linear search when checking child-transaction XIDs.
> Are there any plans to backpatch this into REL8_3_STABLE?
No.
> It looks like I am
> hitting a pretty serious performance regression on 8.3 with a stored
> procedure that grabs a pretty big recordset, and loops through doing
> insert....update on unique failures. The procedure get progressivly slower
> the more records involved... and dbx shows me stuck in
> TransactionIdIsCurrentTransactionId().
If you can convince me it's a regression I might reconsider, but I
rather doubt that 8.2 was better,
regards, tom lane