Re: [HACKERS] parallel restore test results

2008-10-03 Thread Alvaro Herrera
Andrew Dunstan wrote: Overall result: baseline: 4h32m parallel: 0h 54m. Awesome!! -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-hackers mailing list

[HACKERS] parallel restore test results

2008-10-02 Thread Andrew Dunstan
I have just completed a test of the patch I posted a few days ago. The test is a 2Gb dump file that restores to a 22Gb database. The database is very complex, with some 28,000 objects. The baseline test was run in a single transaction: pg_restore --use-list tlist -1 -d mdata