Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 274282E0043 for ; Wed, 20 Feb 2008 09:32:59 -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 57330-02-3 for ; Wed, 20 Feb 2008 09:32:55 -0400 (AST) Received: from hunley.homeip.net (hunley.homeip.net [69.12.222.146]) by postgresql.org (Postfix) with ESMTP id 119252E00D3 for ; Wed, 20 Feb 2008 09:28:34 -0400 (AST) Received: from douglas.hunley.homeip.net (d60-34-189.col.wideopenwest.com [65.60.189.34]) (authenticated bits=0) by hunley.homeip.net (8.13.1/8.13.1) with ESMTP id m1KDSKSX015796 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NOT); Wed, 20 Feb 2008 08:28:26 -0500 From: Douglas J Hunley To: Greg Smith Subject: Re: 7 hrs for a pg_restore? Date: Wed, 20 Feb 2008 08:28:17 -0500 User-Agent: KMail/1.9.7 Cc: pgsql-performance@postgresql.org References: <200802191303.58840.doug@hunley.homeip.net> <200802191358.38614.doug@hunley.homeip.net> In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200802200828.17219.doug@hunley.homeip.net> X-Greylist: Sender succeeded SMTP AUTH authentication, not delayed by milter-greylist-3.0 (hunley.homeip.net [69.12.222.146]); Wed, 20 Feb 2008 08:28:26 -0500 (EST) X-Virus-Scanned: ClamAV version 0.92.1, clamav-milter version 0.92.1 on hunley.homeip.net X-Virus-Status: Clean X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.004 tagged_above=0 required=5 tests=AWL=0.004 X-Spam-Level: X-Archive-Number: 200802/243 X-Sequence-Number: 28785 On Tuesday 19 February 2008 17:53:45 Greg Smith wrote: > 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 excellent! i'll look into doing this. thx! -- Douglas J Hunley (doug at hunley.homeip.net) - Linux User #174778 http://doug.hunley.homeip.net Illiterate? Write for help!