Re: Replication Syatem

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

But unless we do full vacuum the space is not recovered. Thats y we prefer
full vacuum.

~ Gauri

On Tue, Apr 29, 2008 at 10:38 AM, Greg Smith <gsmith@[EMAIL PROTECTED]
> wrote:

> On Tue, 29 Apr 2008, Gauri Kanekar wrote:
>
>  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.
> >
>
> VACUUM FULL needs an exclusive lock, the regular one does not in 8.1.
It's
> one of the reasons FULL should be avoided.  If you do regular VACUUM
> frequently enough, you shouldn't ever need to do a FULL one anyway.
>
>
> --
> * Greg Smith gsmith@[EMAIL PROTECTED]
 http://www.gregsmith.com
Baltimore, MD
>



-- 
Regards
Gauri

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

But unless we do full vacuum the space is not recovered. Thats y we prefer
full vacuum.<br><br>~ Gauri<br><br><div class="gmail_quote">On Tue, Apr 29,
2008 at 10:38 AM, Greg Smith &lt;<a
href="mailto:gsmith@[EMAIL PROTECTED]
">gsmith@[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
class="Ih2E3d">On Tue, 29 Apr 2008, Gauri Kanekar wrote:<br>
<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204,
204, 204); padding-left: 1ex;">
Basically we have some background process which updates &quot;table1&quot;
and we<br>
don&#39;t want the application to make any changes to &quot;table1&quot;
while vacuum.<br>
Vacuum requires exclusive lock on &quot;table1&quot; and if any of the
background or<br>
application is ON vacuum don&#39;t kick off.<br>
</blockquote>
<br></div>
VACUUM FULL needs an exclusive lock, the regular one does not in 8.1.
It&#39;s one of the reasons FULL should be avoided. &nbsp;If you do
regular VACUUM frequently enough, you shouldn&#39;t ever need to do a FULL
one anyway.<div>
<div></div><div class="Wj3C7c"><br>
<br>
--<br>
* Greg Smith <a href="mailto:gsmith@[EMAIL PROTECTED]
"
target="_blank">gsmith@[EMAIL PROTECTED]
> <a
href="http://www.gregsmith.com"
target="_blank">http://www.gregsmith.com</a>
Baltimore, MD<br>
</div></div></blockquote></div><br><br clear="all"><br>--
<br>Regards<br>Gauri

------=_Part_10463_6957960.1209445893338--