X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 91EE59FB383 for ; Wed, 6 Sep 2006 16:32:36 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 30808-09 for ; Wed, 6 Sep 2006 19:32:25 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from main2.mycybernet.net (main2.mycybernet.net [209.222.63.140]) by postgresql.org (Postfix) with ESMTP id 85DCD9FB370 for ; Wed, 6 Sep 2006 16:32:14 -0300 (ADT) Received: from 227-54-222-209.mycybernet.net ([209.222.54.227] helo=phlogiston.dydns.org) by main2.mycybernet.net with esmtp (Exim 4.62) (envelope-from ) id 1GL3My-0004NK-3U for pgsql-admin@postgresql.org; Wed, 06 Sep 2006 15:47:32 -0400 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id 8C7773FAF; Wed, 6 Sep 2006 15:32:08 -0400 (EDT) Date: Wed, 6 Sep 2006 15:32:08 -0400 From: Andrew Sullivan To: pgsql-admin@postgresql.org Subject: Re: transactoin id wraparound problem Message-ID: <20060906193208.GP362@phlogiston.dyndns.org> References: <6992E470F12A444BB787B5C937B9D4DF05ABC88F@ca-mail1.cis.local> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <6992E470F12A444BB787B5C937B9D4DF05ABC88F@ca-mail1.cis.local> User-Agent: Mutt/1.5.9i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.135 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200609/46 X-Sequence-Number: 22960 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