Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 03D5B2E0057 for ; Mon, 28 Apr 2008 11:13:35 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 30958-04 for ; Mon, 28 Apr 2008 11:13:23 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from mx4.ca.afilias.info (vgateway.libertyrms.info [207.219.45.62]) by developer.postgresql.org (Postfix) with ESMTP id CDF6C2E003F for ; Mon, 28 Apr 2008 11:13:23 -0300 (ADT) Received: from dba5.int.libertyrms.com ([10.1.3.44]) by mx4.ca.afilias.info with esmtp (Exim 4.22) id 1JqU6a-0001C9-MG; Mon, 28 Apr 2008 10:13:20 -0400 Subject: Re: Replication Syatem From: Brad Nicholson To: Gauri Kanekar Cc: Peter Childs , pgsql-performance@postgresql.org In-Reply-To: <7e4ba9550804280705q43c51e66l104a5ff9272bbd4d@mail.gmail.com> References: <7e4ba9550804280638ie81dc23w472785c83cd38fcf@mail.gmail.com> <7e4ba9550804280705q43c51e66l104a5ff9272bbd4d@mail.gmail.com> Content-Type: text/plain Date: Mon, 28 Apr 2008 10:13:20 -0400 Message-Id: <1209392000.8872.29.camel@bnicholson-desktop> Mime-Version: 1.0 X-Mailer: Evolution 2.12.1 Content-Transfer-Encoding: 7bit X-SA-Exim-Mail-From: bnichols@ca.afilias.info X-SA-Exim-Scanned: No; SAEximRunCond expanded to false X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200804/392 X-Sequence-Number: 29885 On Mon, 2008-04-28 at 19:35 +0530, Gauri Kanekar wrote: > Peter, > > We are doing vacuum full every alternate day. We also do vacuum > analyze very often. > We are currently using 8.1.3 version. > Auto vacuum is already on. But the table1 is so busy that auto vacuum > don't get sufficient chance to vacuum it :(. You should seriously consider upgrading to PG 8.3. There have been substantial improvements to VACUUM since 8.1 Brad.