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@xxxxxxxxxxxxxxx This work was visionary and imaginative, and goes to show that visionary and imaginative work need not end up well. --Dennis Ritchie
