Re: Replication Syatem

------=_Part_10418_6654278.1209444910506
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Basically we have some background process which updates "table1" and we
don't want the application to make any changes to "table1" while vacuum.

Vacuum requires exclusive lock on "table1" and if any of the background or
application is ON vacuum don't kick off. Thats the reason we need to get
the
site down.

~ Gauri

On Tue, Apr 29, 2008 at 3:13 AM, Chris Browne <cbbrowne@[EMAIL PROTECTED]
> wrote:

> meetgaurikanekar@[EMAIL PROTECTED]
 ("Gauri Kanekar") writes:
> > 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.
>
> The only reason that it would be necessary for VACUUM to "take the
> site down" would be if you are running version 7.1, which was
> obsoleted in 2002, which, it should be noted, was SIX YEARS AGO.
>
> As has been noted, you seem to be presupposing a remarkably complex
> solution to resolve a problem which is likely to be better handled via
> running VACUUM rather more frequently.
> --
> output = reverse("ofni.sesabatadxunil" "@[EMAIL PROTECTED]
" "enworbbc")
> http://www3.sympatico.ca/cbbrowne/postgresql.html
> Rules  of the  Evil Overlord  #181.  "I  will decree  that all  hay be
> ****pped in tightly-packed bales. Any wagonload of loose hay attempting
> to pass through a checkpoint will be set on fire."
> <http://www.eviloverlord.com/>
>
> --
> Sent via pgsql-performance mailing list
(pgsql-performance@[EMAIL PROTECTED]
)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>



-- 
Regards
Gauri

------=_Part_10418_6654278.1209444910506
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<br>Basically we have some background process which updates
&quot;table1&quot; and we don&#39;t want the application to make any
changes to &quot;table1&quot; while vacuum.<br><br>Vacuum requires
exclusive lock on &quot;table1&quot; and if any of the background or
application is ON vacuum don&#39;t kick off. Thats the reason we need to
get the site down.<br>
<br>~ Gauri<br><br><div class="gmail_quote">On Tue, Apr 29, 2008 at 3:13
AM, Chris Browne &lt;<a
href="mailto:cbbrowne@[EMAIL PROTECTED]
">cbbrowne@[EMAIL PROTECTED]
>&gt;
wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid
rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div><div></div><div class="Wj3C7c"><a
href="mailto:meetgaurikanekar@[EMAIL PROTECTED]
">meetgaurikanekar@[EMAIL PROTECTED]
>
(&quot;Gauri Kanekar&quot;) writes:<br>
&gt; We have a table &quot;table1&quot; which get insert and updates daily
in high<br>
&gt; numbers, bcoz of which its size is increasing and we have to
vacuum<br>
&gt; it every alternate day. Vacuuming &quot;table1&quot; take almost
30min and<br>
&gt; during that time the site is down. &nbsp;We need to cut down on
this<br>
&gt; downtime.So thought of having a replication system, for which the<br>
&gt; replicated DB will be up during the master is getting vacuumed.
&nbsp;Can<br>
&gt; anybody guide which will be the best suited replication solution
for<br>
&gt; this.<br>
<br>
</div></div>The only reason that it would be necessary for VACUUM to
&quot;take the<br>
site down&quot; would be if you are running version 7.1, which was<br>
obsoleted in 2002, which, it should be noted, was SIX YEARS AGO.<br>
<br>
As has been noted, you seem to be presupposing a remarkably complex<br>
solution to resolve a problem which is likely to be better handled via<br>
running VACUUM rather more frequently.<br>
<font color="#888888">--<br>
output = reverse(&quot;ofni.sesabatadxunil&quot; &quot;@[EMAIL PROTECTED]
)<br>
<a href="http://www3.sympatico.ca/cbbrowne/postgresql.html"
target="_blank">http://www3.sympatico.ca/cbbrowne/postgresql.html</a><br>
Rules &nbsp;of the &nbsp;Evil Overlord &nbsp;#181. &nbsp;&quot;I
&nbsp;will decree &nbsp;that all &nbsp;hay be<br>
****pped in tightly-packed bales. Any wagonload of loose hay attempting<br>
to pass through a checkpoint will be set on fire.&quot;<br>
&lt;<a href="http://www.eviloverlord.com/"
target="_blank">http://www.eviloverlord.com/</a>&gt;<br>
</font><div><div></div><div class="Wj3C7c"><br>
--<br>
Sent via pgsql-performance mailing list (<a
href="mailto:pgsql-performance@[EMAIL PROTECTED]
">pgsql-performance@[EMAIL PROTECTED]
>)<br>
To make changes to your subscription:<br>
<a href="http://www.postgresql.org/mailpref/pgsql-performance"
target="_blank">http://www.postgresql.org/mailpref/pgsql-performance</a><br>
</div></div></blockquote></div><br><br clear="all"><br>--
<br>Regards<br>Gauri

------=_Part_10418_6654278.1209444910506--