Skip site navigation (1) Skip section navigation (2)

Re: Re: [HACKERS] [COMMITTERS] pgsql: FixTransactionIdIsCurrentTransactionId() to use binary search

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Re: [HACKERS] [COMMITTERS] pgsql: FixTransactionIdIsCurrentTransactionId() to use binary search
Date: 2008-04-21 16:54:24
Message-ID: 20080421165424.GC14464@alvh.no-ip.org (view raw or flat)
Thread:
Lists: pgsql-committerspgsql-hackerspgsql-performance
Robert Treat wrote:

> Unfortunatly I don't have the 8.1 system to bang on anymore for this, (though 
> anecdotaly speaking, I never saw this behavior in 8.1) however I do now have 
> a parallel 8.3 system crunching the data, and it is showing the same symptom 
> (yes, 2 8.3 servers, crunching the same data, both bogged down now), so I do 
> feel this is something specific to 8.3.  
> 
> I am mostly wondering if anyone else has encountered behavior like this on 8.3 
> (large sets of insert....update exception block in plpgsql bogging down), or 
> if anyone has any thoughts on which direction I should poke at it from here. 
> TIA.

Perhaps what you could do is backpatch the change and see if the problem
goes away.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

In response to

Responses

pgsql-performance by date

Next:From: PFCDate: 2008-04-21 23:34:40
Subject: Re: Group by more efficient than distinct?
Previous:From: Robert TreatDate: 2008-04-21 16:29:00
Subject: Re: [HACKERS] [COMMITTERS] pgsql: Fix TransactionIdIsCurrentTransactionId() to use binary search

pgsql-hackers by date

Next:From: Greg SmithDate: 2008-04-21 16:56:02
Subject: Re: Commitfest namespacing (was: TODO, FAQs to Wiki?)
Previous:From: Brendan JurdDate: 2008-04-21 16:54:16
Subject: Re: Commitfest namespacing (was: TODO, FAQs to Wiki?)

pgsql-committers by date

Next:From: Andrew DunstanDate: 2008-04-21 16:55:55
Subject: Re: pgsql: Make float4byval and float8byval configurable on MSVC.
Previous:From: Robert TreatDate: 2008-04-21 16:29:00
Subject: Re: [HACKERS] [COMMITTERS] pgsql: Fix TransactionIdIsCurrentTransactionId() to use binary search

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group