| 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: Fix TransactionIdIsCurrentTransactionId() to use binary search |
| Date: | 2008-04-21 16:54:24 |
| Message-ID: | 20080421165424.GC14464@alvh.no-ip.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers pgsql-hackers pgsql-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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Dunstan | 2008-04-21 16:55:55 | Re: pgsql: Make float4byval and float8byval configurable on MSVC. |
| Previous Message | Robert Treat | 2008-04-21 16:29:00 | Re: [HACKERS] [COMMITTERS] pgsql: Fix TransactionIdIsCurrentTransactionId() to use binary search |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Smith | 2008-04-21 16:56:02 | Re: Commitfest namespacing (was: TODO, FAQs to Wiki?) |
| Previous Message | Brendan Jurd | 2008-04-21 16:54:16 | Re: Commitfest namespacing (was: TODO, FAQs to Wiki?) |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | PFC | 2008-04-21 23:34:40 | Re: Group by more efficient than distinct? |
| Previous Message | Robert Treat | 2008-04-21 16:29:00 | Re: [HACKERS] [COMMITTERS] pgsql: Fix TransactionIdIsCurrentTransactionId() to use binary search |