Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 7AA2E2E00C6 for ; Thu, 20 Mar 2008 07:36:31 -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 91290-01 for ; Thu, 20 Mar 2008 07:36:18 -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 C19A82E00C4 for ; Thu, 20 Mar 2008 07:36:18 -0300 (ADT) Received: from depesz by depesz.com with local (Exim 4.63) (envelope-from ) id 1JcI87-0002mw-KY; Thu, 20 Mar 2008 11:36:15 +0100 Date: Thu, 20 Mar 2008 11:36:15 +0100 From: hubert depesz lubaczewski To: Aftab Alam Cc: pgsql-admin@postgresql.org Subject: Re: Postgres Performance Message-ID: <20080320103615.GA10677@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.663 tagged_above=0 required=5 tests=AWL=-1.534, FAKE_REPLY_C=2.197 X-Spam-Level: X-Archive-Number: 200803/163 X-Sequence-Number: 28646 On Thu, Mar 20, 2008 at 04:02:48PM +0530, Aftab Alam wrote: > I have mistaken written 7.0 instead of 7.3, I am getting more than 2000 hits > daily, can u suggest the best configuration. Mean while I am trying to > migrate it to 8.3.1 7.3 is also pretty old. as for 2000 hits daily - it's not much. do you have performance issues? check which queries couse the problems, and "explain analyze" them. then, with explain analyze output, you can fix performance issues in those queries. regards, depesz -- 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)