Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 511E12E0056 for ; Thu, 20 Mar 2008 06:57:22 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 69974-06 for ; Thu, 20 Mar 2008 06:57:19 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from depesz.com (depesz.com [88.198.37.40]) by postgresql.org (Postfix) with ESMTP id 6F6DE2E004D for ; Thu, 20 Mar 2008 06:57:19 -0300 (ADT) Received: from depesz by depesz.com with local (Exim 4.63) (envelope-from ) id 1JcHWM-0002Ti-UX; Thu, 20 Mar 2008 10:57:14 +0100 Date: Thu, 20 Mar 2008 10:57:14 +0100 From: hubert depesz lubaczewski To: Aftab Alam Cc: pgsql-admin@postgresql.org Subject: Re: Postgres Performance Message-ID: <20080320095714.GA9423@depesz.com> Reply-To: depesz@depesz.com MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.656 tagged_above=0 required=5 tests=AWL=-1.541, FAKE_REPLY_C=2.197 X-Spam-Level: X-Archive-Number: 200803/161 X-Sequence-Number: 28644 On Thu, Mar 20, 2008 at 03:12:43PM +0530, Aftab Alam wrote: > 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. the best setting would be to upgrade. 7.0 was released in 2000, and is practically abandoned. the oldest supported version at the moment is 7.4, but i would strongly suggest to try to move to newest versions - like 8.3.1 regards, hubert lubaczewski -- quicksil1er: "postgres is excellent, but like any DB it requires a highly paid DBA. here's my CV!" :) http://www.depesz.com/ - blog dla ciebie (i moje CV)