Re: [COMMITTERS] pgsql: Fix TransactionIdIsCurrentTransactionId() to use binary search - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [COMMITTERS] pgsql: Fix TransactionIdIsCurrentTransactionId() to use binary search
Date
Msg-id 2092.1206652297@sss.pgh.pa.us
Whole thread Raw
In response to Re: [COMMITTERS] pgsql: Fix TransactionIdIsCurrentTransactionId() to use binary search  (Robert Treat <xzilla@users.sourceforge.net>)
Responses Re: [COMMITTERS] pgsql: Fix TransactionIdIsCurrentTransactionId() to use binary search
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Robert Treat
Date:
Subject: Re: [COMMITTERS] pgsql: Fix TransactionIdIsCurrentTransactionId() to use binary search
Next
From: Keaton Adams
Date:
Subject: PostgreSQL Replication with read-only access to standby DB