Re: 7 hrs for a pg_restore?

From: Greg Smith <gsmith(at)gregsmith(dot)com>
To: Douglas J Hunley <doug(at)hunley(dot)homeip(dot)net>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: 7 hrs for a pg_restore?
Date: 2008-02-19 22:53:45
Message-ID: Pine.GSO.4.64.0802191751310.22515@westnet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Greg Smith 2008-02-19 22:57:21 Re: Fwd: wal_sync_methods for AIX
Previous Message Erik Jones 2008-02-19 22:09:41 Re: wal_sync_methods for AIX