Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 014022E0039 for ; Thu, 20 Mar 2008 19:13:59 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 61301-04 for ; Thu, 20 Mar 2008 19:13:47 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from polaris.pinpointresearch.com (66-7-238-130.static-ip.telepacific.net [66.7.238.130]) by postgresql.org (Postfix) with ESMTP id D944C2E0033 for ; Thu, 20 Mar 2008 19:13:51 -0300 (ADT) Received: from [192.168.1.179] (betelgeuse.pinpointresearch.com [192.168.1.179]) by polaris.pinpointresearch.com (Postfix) with ESMTP id 4BAEEE00EC80; Thu, 20 Mar 2008 15:13:49 -0700 (PDT) Message-ID: <47E2E19D.1050909@pinpointresearch.com> Date: Thu, 20 Mar 2008 15:13:49 -0700 From: Steve Crawford User-Agent: Thunderbird 2.0.0.12 (X11/20080227) MIME-Version: 1.0 To: Aftab Alam CC: pgsql-admin@postgresql.org Subject: Re: Postgres Performance References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/181 X-Sequence-Number: 28664 Aftab Alam wrote: > > Dear All, > > > > I am using postgres 7.0 with linux with 15 GB of database > & 3 gb of RAM. > > Can anyone suggest what is the best setting for postgres. I am using > postgres as web db. > > I'm going to assume/hope that you mean 8.0. Even then, you would be well advised to upgrade. 8.0 is over three years old and no amount of tuning will make it as fast as the newer releases. Then look at http://www.google.com/search?q=postgresql+tuning The Varlena articles are good even if dated. After reading a few pages and trying a bit of experimentation, check back with unanswered questions. Nobody can recommend a "best setting" without a thorough understanding of your workload. Or even if they do - guidelines/suggestions is the best you will find. Cheers, Steve