Testing of parallel restore with current snapshot

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Testing of parallel restore with current snapshot
Date: 2009-05-15 04:15:01
Message-ID: 4A0CEC45.1090608@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Andrew, Tom,

Just wanted to remark on my tests of this feature since the last set of
patches.

First of all, no locking. Yay.

Andrew's latest algorithm tends to result in building indexes on the
same table at the same time. This is excellent for most users; I'm on a
client's site which is I/O bound and that approach is speeding up
parallel load about 20% compared to the beta1 version.

In other words, don't mess with it now. I think it's perfect. ;-)

--
Josh Berkus
PostgreSQL Experts Inc.
www.pgexperts.com

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Heikki Linnakangas 2009-05-15 06:06:48 Re: pgsql: Add recovery_end_command option to recovery.conf.
Previous Message Fujii Masao 2009-05-15 02:32:59 Re: New trigger option of pg_standby