Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 981342E007A for ; Tue, 19 Feb 2008 18:54:14 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 81713-01-7 for ; Tue, 19 Feb 2008 18:54:09 -0400 (AST) Received: from westnet.com (westnet.com [216.187.52.2]) by postgresql.org (Postfix) with ESMTP id B2B982E005F for ; Tue, 19 Feb 2008 18:53:53 -0400 (AST) Received: from westnet.com (localhost [127.0.0.1]) by westnet.com (8.14.0/8.14.0) with ESMTP id m1JMrj3O002548; Tue, 19 Feb 2008 17:53:45 -0500 (EST) Received: from localhost (gsmith@localhost) by westnet.com (8.14.0/8.13.2/Submit) with ESMTP id m1JMrjfk002544; Tue, 19 Feb 2008 17:53:45 -0500 (EST) X-Authentication-Warning: westnet.com: gsmith owned process doing -bs Date: Tue, 19 Feb 2008 17:53:45 -0500 (EST) From: Greg Smith X-X-Sender: gsmith@westnet.com To: Douglas J Hunley cc: pgsql-performance@postgresql.org Subject: Re: 7 hrs for a pg_restore? In-Reply-To: <200802191358.38614.doug@hunley.homeip.net> Message-ID: References: <200802191303.58840.doug@hunley.homeip.net> <20080219101254.754bd94d@commandprompt.com> <200802191358.38614.doug@hunley.homeip.net> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/234 X-Sequence-Number: 28776 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