On Wed, Sep 06, 2006 at 12:23:01PM -0700, Sriram Dandapani wrote:
> Thanks
>
> Is there a way to monitor vacuum progress. Can I resume normal
> operations assuming vacuum will update the transaction ids or should I
> wait till it finishes.

That depends on how many transactions you think will happen while
vacuum is running. If it's a lot, you could pass the fatal point (==
you lose data) before vacuum finishes. In most cases, it's probably
ok, but only you can decide how dangerous it would be for you to lose
data.

A

--
Andrew Sullivan | ajs@crankycanuck.ca
This work was visionary and imaginative, and goes to show that visionary
and imaginative work need not end up well.
--Dennis Ritchie

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend