On Sunday 16 March 2008 22:18, Tom Lane wrote: > Log Message: > ----------- > Fix TransactionIdIsCurrentTransactionId() to use binary search instead of > linear search when checking child-transaction XIDs. This makes for an > important speedup in transactions that have large numbers of children, > as in a recent example from Craig Ringer. We can also get rid of an > ugly kluge that represented lists of TransactionIds as lists of OIDs. >
Are there any plans to backpatch this into REL8_3_STABLE? 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(). I can provide provide more details if needed (lmk what your looking for) but it certainly looks like the issue discussed here: http://archives.postgresql.org/pgsql-performance/2008-03/msg00191.php -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
