Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id C79C82E009F for ; Thu, 21 Feb 2008 08:24:05 -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 07448-06 for ; Thu, 21 Feb 2008 08:24:02 -0400 (AST) Received: from beaver.fastcrypt.com (beaver.fastcrypt.com [64.7.141.17]) by postgresql.org (Postfix) with ESMTP id 9E9F12E009B for ; Thu, 21 Feb 2008 08:24:02 -0400 (AST) Received: from [192.168.1.14] (dcdsl.ebox.com [64.7.143.116]) by beaver.fastcrypt.com (Postfix) with ESMTP id 46020158036C; Thu, 21 Feb 2008 07:27:28 -0500 (EST) Cc: pgsql-performance@postgresql.org Message-Id: <0DCE2361-E0B5-49F3-9E4D-B87B06DFBADC@fastcrypt.com> From: Dave Cramer To: bh yuan In-Reply-To: <3c7b84c00802202113x3a705e34u9d9cf307fdde8048@mail.gmail.com> Content-Type: text/plain; charset=US-ASCII; format=flowed Content-Transfer-Encoding: 7bit Mime-Version: 1.0 (Apple Message framework v919.2) Subject: Re: Question about shared_buffers and cpu usage Date: Thu, 21 Feb 2008 07:24:01 -0500 References: <3c7b84c00802202113x3a705e34u9d9cf307fdde8048@mail.gmail.com> X-Mailer: Apple Mail (2.919.2) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/265 X-Sequence-Number: 28807 On 21-Feb-08, at 12:13 AM, bh yuan wrote: > Hi > > I am using Postgres8.3 on 8G memory , Xeon X5355 Quad Core x 2 > processer RH5 machine with 10G data. (with some table which have > about 2,000,000~ 5,000,000 rows ) > > I have two quesion. > 1. how to set the shared_buffers and other postgresql.conf parameter > for best performance? > I only run the Postgres8.3 on the machine so I set the shared_buffers > = 7168MB (7G) > But somebody said it is too big, so confused. Yes, it is too big! make it 2G to start >