Re: slow commits with heavy temp table usage in 8.4.0 - Mailing list pgsql-hackers

From Tom Lane
Subject Re: slow commits with heavy temp table usage in 8.4.0
Date
Msg-id 23440.1249661768@sss.pgh.pa.us
Whole thread Raw
In response to Re: slow commits with heavy temp table usage in 8.4.0  ("Todd A. Cook" <tcook@blackducksoftware.com>)
Responses Re: slow commits with heavy temp table usage in 8.4.0  ("Todd A. Cook" <tcook@blackducksoftware.com>)
List pgsql-hackers
"Todd A. Cook" <tcook@blackducksoftware.com> writes:
> Tom Lane wrote:
>> The attached prototype patch does this
>> and seems to fix the speed problem nicely.  It's not tremendously
>> well tested, but perhaps you'd like to test?  Should work in 8.4.

> With the patch applied, the test only took 35 seconds, and the commit
> was practically instant (30ms).

I know it's faster, what I meant by testing was does it *work*.  If you
roll back a truncate, do you get the expected state?  How about after a
database crash?

> Is there any chance that it will be backpatched to 8.4?

Not a lot.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Sam Mason
Date:
Subject: Re: Review: Revise parallel pg_restore's scheduling heuristic
Next
From: Sam Mason
Date:
Subject: Re: Fixing geometic calculation