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
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers