Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

Next:From: Greg SmithDate: 2008-02-19 22:57:21
Subject: Re: Fwd: wal_sync_methods for AIX
Previous:From: Erik JonesDate: 2008-02-19 22:09:41
Subject: Re: wal_sync_methods for AIX

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group