X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 2B1F59FA5CE for ; Tue, 12 Sep 2006 12:18:59 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 57130-10 for ; Tue, 12 Sep 2006 12:18:41 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from my.endian.it (unknown [62.146.87.34]) by postgresql.org (Postfix) with ESMTP id E7F559FA465 for ; Tue, 12 Sep 2006 12:18:40 -0300 (ADT) Received: from ultra.home.lan (host55-111-dynamic.4-87-r.retail.telecomitalia.it [87.4.111.55]) (authenticated (0 bits)) by my.endian.it (8.11.6/8.11.6) with ESMTP id k8CFRsT21049; Tue, 12 Sep 2006 17:27:54 +0200 Subject: Re: Reg - Autovacuum From: Chris Mair To: krishnaraj D Cc: pgsql-performance@postgresql.org In-Reply-To: <4506CA5E.2030305@assyst-international.com> References: <4506CA5E.2030305@assyst-international.com> Content-Type: text/plain Date: Tue, 12 Sep 2006 17:18:27 +0200 Message-Id: <1158074307.1778.16.camel@ultra.home.lan> Mime-Version: 1.0 X-Mailer: Evolution 2.6.3 (2.6.3-1.fc5.5) Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.263 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200609/88 X-Sequence-Number: 20774 > Hi All > I have installed a application with postgres-8.1.4 , I > have to optimize the performance, As a measure i thought of enabling > Auto commit , is it a right decision to take , If correct please suggest > the steps that i need to follow in order to implement the Auto Vacuum. http://www.postgresql.org/docs/8.1/static/maintenance.html#AUTOVACUUM > > And also please suggest other steps that i need to > improve the performance . > http://www.powerpostgresql.com/PerfList Bye, Chris. -- Chris Mair http://www.1006.org