Re: 7 hrs for a pg_restore? - Mailing list pgsql-performance

From Greg Smith
Subject Re: 7 hrs for a pg_restore?
Date
Msg-id Pine.GSO.4.64.0802191751310.22515@westnet.com
Whole thread Raw
In response to Re: 7 hrs for a pg_restore?  (Douglas J Hunley <doug@hunley.homeip.net>)
Responses Re: 7 hrs for a pg_restore?  (Douglas J Hunley <doug@hunley.homeip.net>)
List 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

pgsql-performance by date:

Previous
From: Erik Jones
Date:
Subject: Re: wal_sync_methods for AIX
Next
From: Greg Smith
Date:
Subject: Re: Fwd: wal_sync_methods for AIX