Re: [COMMITTERS] pgsql: Fix TransactionIdIsCurrentTransactionId() to use binary search
| От | Tom Lane |
|---|---|
| Тема | Re: [COMMITTERS] pgsql: Fix TransactionIdIsCurrentTransactionId() to use binary search |
| Дата | |
| Msg-id | 2092.1206652297@sss.pgh.pa.us обсуждение исходный текст |
| Ответ на | Re: [COMMITTERS] pgsql: Fix TransactionIdIsCurrentTransactionId() to use binary search (Robert Treat <xzilla@users.sourceforge.net>) |
| Ответы |
Re: [COMMITTERS] pgsql: Fix
TransactionIdIsCurrentTransactionId() to use binary search
|
| Список | 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 по дате отправления: