Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id E69142E003D for ; Mon, 28 Apr 2008 11:19:22 -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-10 for ; Mon, 28 Apr 2008 11:18:46 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from rn-out-0910.google.com (rn-out-0910.google.com [64.233.170.188]) by developer.postgresql.org (Postfix) with ESMTP id 53D5F2E0033 for ; Mon, 28 Apr 2008 11:18:53 -0300 (ADT) Received: by rn-out-0910.google.com with SMTP id i24so2085264rng.0 for ; Mon, 28 Apr 2008 07:18:49 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; bh=oAF1TIVLKj83+YvhsbIf9wq0k5FMs3Pa9C1Qeu/4STs=; b=t95JKyfG+mtKxZrfgizc4HLo7eiOXhGB+3cE72nEO6gSCCtWJnhp4u8+WDHpcsn1KE8Yn18gW6oNUVRINwXsn2pBMTPEpHXf2Abjz2nn8Ph9kD/NSBMHf2nmXfOqjhJskAlIfqNZGsBLrOFzg60lK3yr0cWr8xlszl7RH3jj0ho= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=EjWLbxbhubqzUVCg9yXYETihAnvF2uBPM9CNpVD23Od8vt8cJi2VXzsePaF2L+5eWeP7oWy68czrDLpnbWDk1XBtN98D/XGfOowovYgt0MDXnlryUCz3VFdogT9hwxG3fW3yhxZardf5ljRk6qJdAIX5t1UXW/LEIaGS3A6hKxM= Received: by 10.114.155.1 with SMTP id c1mr6466648wae.105.1209392328734; Mon, 28 Apr 2008 07:18:48 -0700 (PDT) Received: by 10.114.240.17 with HTTP; Mon, 28 Apr 2008 07:18:48 -0700 (PDT) Message-ID: <7e4ba9550804280718g175000bcj97118c96d4072ec0@mail.gmail.com> Date: Mon, 28 Apr 2008 19:48:48 +0530 From: "Gauri Kanekar" To: salman Subject: Re: Replication Syatem Cc: "Peter Childs" , pgsql-performance@postgresql.org In-Reply-To: <4815DC4C.9060509@quietcaresystems.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_5681_30320931.1209392328729" References: <7e4ba9550804280638ie81dc23w472785c83cd38fcf@mail.gmail.com> <7e4ba9550804280705q43c51e66l104a5ff9272bbd4d@mail.gmail.com> <4815DC4C.9060509@quietcaresystems.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.362 tagged_above=0 required=5 tests=AWL=-1.538, FS_REPLICA=1.179, HTML_MESSAGE=0.001, SARE_SPEC_REPLICA=0.72 X-Spam-Level: X-Archive-Number: 200804/395 X-Sequence-Number: 29888 ------=_Part_5681_30320931.1209392328729 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Salman, Slony don't do automatic failover. And we would appreciate a system with automatic failover :( ~ Gauri On Mon, Apr 28, 2008 at 7:46 PM, salman wrote: > 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 > -- Regards Gauri ------=_Part_5681_30320931.1209392328729 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Salman,

Slony don't do automatic failover. And we would appreciate a system with automatic failover :(

~ Gauri


On Mon, Apr 28, 2008 at 7:46 PM, salman <salmanb@quietcaresystems.com> wrote:
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



--
Regards
Gauri ------=_Part_5681_30320931.1209392328729--