| From: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
|---|---|
| To: | Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc> |
| Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: WIP parallel restore patch |
| Date: | 2008-11-05 15:19:02 |
| Message-ID: | 4911B966.3090509@dunslane.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Stefan Kaltenbrunner wrote:
> Andrew Dunstan wrote:
>>
>> Attached is my latest parallel restore patch. I think it's
>> functionally complete for Unix.
>>
>> Many bugs have been fixed since the last patch, and the hardcoded
>> limitation to two table dependencies is removed. It seems fairly
>> robust in my recent testing.
>
> this version seems to be working much better on my test setup.
> This patch results in a fairly nice improvment from ~170min (-m 1
> --truncate-before-load) to ~39min (-m 16 --truncate-before-load) on my
> 8 core test box using a 70GB (uncompressed) dump consisting of 709
> tables.
>
>
>
Great. Thanks for the report.
cheers
andrew
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2008-11-05 15:20:41 | Re: Proposed Patch to Improve Performance of Multi-Batch Hash Join for Skewed Data Sets |
| Previous Message | Andrew Dunstan | 2008-11-05 15:16:54 | Re: The suppress_redundant_updates_trigger() works incorrectly |