some PITR performance data with DBT-2

Hi Simon, 

Sorry it has taken so long.  Among other things, I doubled the controllers
and drives on the system I was testing this on.  But now I have some data
against PostgreSQL-8.0beta2.

Here is the test run with archiving enabled:http://www.osdl.org/projects/dbt2dev/results/dev4-010/158/

Here is the test run with archiving disabled:http://www.osdl.org/projects/dbt2dev/results/dev4-010/159/

Here is sar/iostat/vmstat and oprofile data during the first hour of
recovery.  Total recovery time took about 6.5 hours:http://www.developer.osdl.org/markw/pitr/

The overall throughput difference between the two runs with archiving
enabled/disabled was within 1%.

I ran the test over a duration of 3 hours (including a 2 hour rampup of
the driver), as opposed to the 6 hours you originally requested.  I
hope that is ok.

System details, which you may be interested in:

4 x 1.5 GHz Itanium 2
16GB RAM
6 x Compaq Computer Corporation Smart Array 64xx
6 x 14 disk 15K RPM drives (split bus)

The database and archive directory were put onto a single LVM volume
across all 84 drives.

Let me know if I left anything out.

-- 
Mark Wong - - markw@osdl.org
Open Source Development Lab Inc - A non-profit corporation
12725 SW Millikan Way - Suite 400 - Beaverton, OR 97005
(503) 626-2455 x 32 (office)
(503) 626-2436      (fax)
http://developer.osdl.org/markw/