Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id ED17A2E005A for ; Mon, 28 Apr 2008 11:16:56 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 45553-09 for ; Mon, 28 Apr 2008 11:16:41 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from livingmail01.inetu.net (unknown [209.235.247.80]) by developer.postgresql.org (Postfix) with ESMTP id 1ED482E0057 for ; Mon, 28 Apr 2008 11:16:48 -0300 (ADT) Received: (qmail 5625 invoked by uid 0); 28 Apr 2008 14:16:44 -0000 Received: from unknown (HELO ?192.168.0.23?) (salmanb@quietcaresystems.com@127.0.0.1) by livingmail01.inetu.net with SMTP; 28 Apr 2008 14:16:44 -0000 Message-ID: <4815DC4C.9060509@quietcaresystems.com> Date: Mon, 28 Apr 2008 10:16:44 -0400 From: salman User-Agent: Mozilla-Thunderbird 2.0.0.12 (X11/20080420) MIME-Version: 1.0 To: Gauri Kanekar CC: Peter Childs , pgsql-performance@postgresql.org Subject: Re: Replication Syatem References: <7e4ba9550804280638ie81dc23w472785c83cd38fcf@mail.gmail.com> <7e4ba9550804280705q43c51e66l104a5ff9272bbd4d@mail.gmail.com> In-Reply-To: <7e4ba9550804280705q43c51e66l104a5ff9272bbd4d@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.984 tagged_above=0 required=5 tests=AWL=-1.015, FS_REPLICA=1.179, RDNS_NONE=0.1, SARE_SPEC_REPLICA=0.72 X-Spam-Level: X-Archive-Number: 200804/393 X-Sequence-Number: 29886 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 :(. > > Have already tried all the option listed by you, thats y we reached to the > decision of having a replication sytsem. So any suggestion on that :). > > Thanx > ~ Gauri > We use slony for exactly this type of a situation. It's not the most user-friendly piece of software, but it works well enough that I can schedule maintenance windows (we're a 24/7 shop) and do clustering and other tasks on our DB to reclaim space, etc. -salman