Horton

Re: 7 hrs for a pg_restore?

Greg Smith <gsmith@gregsmith.com>

View thread
From: Greg Smith <gsmith@gregsmith.com>
To: Douglas J Hunley <doug@hunley.homeip.net>
Cc: pgsql-performance@postgresql.org
Date: 2008-02-19T22:53:45Z
Lists: pgsql-performance 
On Tue, 19 Feb 2008, Douglas J Hunley wrote:

> The db resides on a HP Modular Storage Array 500 G2. 4x72.8Gb 15k rpm disks. 1
> raid 6 logical volume. Compaq Smart Array 6404 controller

You might consider doing some simple disk tests on the array just to prove 
it's working well.  Reports here suggest the HP/Compaq arrays have been 
somewhat inconsistant in performance, and it would be helpful to know if 
you've got a good or a bad setup.  Some hints here are at 
http://www.westnet.com/~gsmith/content/postgresql/pg-disktesting.htm

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD