Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 884C42E002C for ; Tue, 19 Feb 2008 16:17:01 -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 69943-07 for ; Tue, 19 Feb 2008 16:16:44 -0400 (AST) Received: from beaver.fastcrypt.com (beaver.fastcrypt.com [64.7.141.17]) by postgresql.org (Postfix) with ESMTP id AD53F2E003D for ; Tue, 19 Feb 2008 16:16:44 -0400 (AST) Received: from [192.168.1.14] (dcdsl.ebox.com [64.7.143.116]) by beaver.fastcrypt.com (Postfix) with ESMTP id 7CA241580368; Tue, 19 Feb 2008 15:19:58 -0500 (EST) Cc: "Joshua D. Drake" , pgsql-performance@postgresql.org Message-Id: <7D7AD56B-7AEE-41F5-A2A6-EE1D6B80B656@fastcrypt.com> From: Dave Cramer To: Douglas J Hunley In-Reply-To: <200802191435.58720.doug@hunley.homeip.net> Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes 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 15:16:42 -0500 References: <200802191303.58840.doug@hunley.homeip.net> <200802191358.38614.doug@hunley.homeip.net> <50E6AB07-AEEB-4DBA-9994-C87CD773E9A6@fastcrypt.com> <200802191435.58720.doug@hunley.homeip.net> X-Mailer: Apple Mail (2.919.2) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/227 X-Sequence-Number: 28769 On 19-Feb-08, at 2:35 PM, Douglas J Hunley wrote: > On Tuesday 19 February 2008 14:28:54 Dave Cramer wrote: >> shared buffers is *way* too small as is effective cache >> set them to 2G/6G respectively. >> >> Dave > > pardon my ignorance, but is this in the context of a restore only? > or 'in > general'? This is the "generally accepted" starting point for a pg db for production. > > > -- > Douglas J Hunley (doug at hunley.homeip.net) - Linux User #174778 > http://doug.hunley.homeip.net > > Don't let Kirk show you what he affectionately calls the "Captain's > Log" > > ---------------------------(end of > broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match