Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id B14E52E005C for ; Fri, 21 Mar 2008 16:50:16 -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 81043-07 for ; Fri, 21 Mar 2008 16:50:13 -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 D1C152E0056 for ; Fri, 21 Mar 2008 16:50:13 -0300 (ADT) Received: from [192.168.1.179] (betelgeuse.pinpointresearch.com [192.168.1.179]) by polaris.pinpointresearch.com (Postfix) with ESMTP id F27EBE00EC82; Fri, 21 Mar 2008 12:50:10 -0700 (PDT) Message-ID: <47E41172.5000400@pinpointresearch.com> Date: Fri, 21 Mar 2008 12:50:10 -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: <47E2E19D.1050909@pinpointresearch.com> In-Reply-To: <47E2E19D.1050909@pinpointresearch.com> 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/185 X-Sequence-Number: 28668 > 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. You mentioned elsewhere that you are getting 2,000 hits/day. I don't know the nature of your web app but typical web apps involve pretty simple transactions. Even with an average of 10 database transactions per hit, your average is less than 0.25 TPS - several orders of magnitude lower than the likely capacity of your hardware. If you are experiencing performance problems I think that you may need to look into more than the config file: 1. Are you vacuuming regularly? If not, you may need a vacuum full followed by regular vacuuming. 2. Have you established appropriate indexes? 3. Are you running analyze to allow the planner to use the indexes you created? Cheers, Steve