| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Todd A(dot) Cook" <tcook(at)blackducksoftware(dot)com> |
| Cc: | Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: slow commits with heavy temp table usage in 8.4.0 |
| Date: | 2009-08-07 16:16:08 |
| Message-ID: | 23440.1249661768@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
"Todd A. Cook" <tcook(at)blackducksoftware(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alex Hunsaker | 2009-08-07 16:23:27 | Re: slow commits with heavy temp table usage in 8.4.0 |
| Previous Message | Sam Mason | 2009-08-07 16:12:56 | Re: Review: Revise parallel pg_restore's scheduling heuristic |