Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 6C0F12E0068 for ; Tue, 19 Feb 2008 15:39:56 -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 59651-01-3 for ; Tue, 19 Feb 2008 15:39:49 -0400 (AST) Received: from beaver.fastcrypt.com (beaver.fastcrypt.com [64.7.141.17]) by postgresql.org (Postfix) with ESMTP id D60092E00FB for ; Tue, 19 Feb 2008 15:28:55 -0400 (AST) Received: from [192.168.1.14] (dcdsl.ebox.com [64.7.143.116]) by beaver.fastcrypt.com (Postfix) with ESMTP id 46B4B1580368; Tue, 19 Feb 2008 14:32:10 -0500 (EST) Cc: "Joshua D. Drake" , pgsql-performance@postgresql.org Message-Id: <50E6AB07-AEEB-4DBA-9994-C87CD773E9A6@fastcrypt.com> From: Dave Cramer To: Douglas J Hunley In-Reply-To: <200802191358.38614.doug@hunley.homeip.net> Content-Type: text/plain; charset=US-ASCII; format=flowed Content-Transfer-Encoding: 7bit Mime-Version: 1.0 (Apple Message framework v919.2) Subject: Re: 7 hrs for a pg_restore? Date: Tue, 19 Feb 2008 14:28:54 -0500 References: <200802191303.58840.doug@hunley.homeip.net> <20080219101254.754bd94d@commandprompt.com> <200802191358.38614.doug@hunley.homeip.net> X-Mailer: Apple Mail (2.919.2) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/222 X-Sequence-Number: 28764 shared buffers is *way* too small as is effective cache set them to 2G/6G respectively. Dave