Re: transactoin id wraparound problem

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