Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id 70BA12E0038 for ; Mon, 28 Apr 2008 10:39:02 -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 34674-04 for ; Mon, 28 Apr 2008 10:38:50 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.179]) by developer.postgresql.org (Postfix) with ESMTP id 304412E004D for ; Mon, 28 Apr 2008 10:38:57 -0300 (ADT) Received: by wa-out-1112.google.com with SMTP id n7so8081253wag.5 for ; Mon, 28 Apr 2008 06:38:56 -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:mime-version:content-type; bh=/8rb0zitrE2qjr38qxxCv3XSccuKeqQa+0UHWcvnnqo=; b=FVRUeKgVjM4ePw7sw80J2y7RKhjQQ6gymS8BriwZk0StpLAuclxlxdPWfRv1Lqufm7So7r9DuP2HgJowqdNd1n9HXJhjuP1l566tSR8vwLdIGVmLvwrfjFdzOGHmyTttyUplF7oBlPQZBS1Y7Licti6VLYr0fNcB84Eck+VqtBI= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:mime-version:content-type; b=o70aZSfRELtoFa4/IzSeLupI1JZGW4RAihAtEwF3jH03O0uteX1QBX9ndBriitcPeMxOl+VFncPIqL7KDsD329gG03G8dtRDBk3lW1KWC7Y6uAazAFtpPqVN3wSQU4EM2U6YVlZ2dmOmLT12ff0q5AcRVTAN/H9IxxS8gaADtgA= Received: by 10.114.120.1 with SMTP id s1mr6403669wac.137.1209389936480; Mon, 28 Apr 2008 06:38:56 -0700 (PDT) Received: by 10.114.240.17 with HTTP; Mon, 28 Apr 2008 06:38:56 -0700 (PDT) Message-ID: <7e4ba9550804280638ie81dc23w472785c83cd38fcf@mail.gmail.com> Date: Mon, 28 Apr 2008 19:08:56 +0530 From: "Gauri Kanekar" To: pgsql-performance@postgresql.org Subject: Replication Syatem MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_5233_25137124.1209389936476" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.9 tagged_above=0 required=5 tests=FS_REPLICA=1.179, HTML_MESSAGE=0.001, SARE_SPEC_REPLICA=0.72 X-Spam-Level: * X-Archive-Number: 200804/389 X-Sequence-Number: 29882 ------=_Part_5233_25137124.1209389936476 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline All, We have a table "table1" which get insert and updates daily in high numbers, bcoz of which its size is increasing and we have to vacuum it every alternate day. Vacuuming "table1" take almost 30min and during that time the site is down. We need to cut down on this downtime.So thought of having a replication system, for which the replicated DB will be up during the master is getting vacuumed. Can anybody guide which will be the best suited replication solution for this. Thanx for any help ~ Gauri ------=_Part_5233_25137124.1209389936476 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline All,

We have a table "table1" which get insert and updates daily in high numbers, bcoz of which its size is increasing and we have to vacuum it every alternate day. Vacuuming "table1" take almost 30min and during that time the site is down.

We need to cut down on this downtime.So thought of having a replication system, for which the replicated DB will be up during the master is getting vacuumed.

Can anybody guide which will be the best suited replication solution for this.

Thanx for any help
~ Gauri
------=_Part_5233_25137124.1209389936476--