Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 58B489FBE7F for ; Wed, 8 Aug 2007 13:20:43 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 07737-02 for ; Wed, 8 Aug 2007 13:20:39 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from nz-out-0506.google.com (nz-out-0506.google.com [64.233.162.230]) by postgresql.org (Postfix) with ESMTP id D3A849FC043 for ; Wed, 8 Aug 2007 13:20:09 -0300 (ADT) Received: by nz-out-0506.google.com with SMTP id l8so79661nzf for ; Wed, 08 Aug 2007 09:20:07 -0700 (PDT) Received: by 10.142.191.2 with SMTP id o2mr447936wff.1186590007057; Wed, 08 Aug 2007 09:20:07 -0700 (PDT) Received: by 10.142.101.19 with HTTP; Wed, 8 Aug 2007 09:20:07 -0700 (PDT) Message-ID: Date: Wed, 8 Aug 2007 12:20:07 -0400 From: "Nick Fankhauser" To: pgsql-admin@postgresql.org Subject: Re: Specific questions about wraparound and vacuum In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: X-Google-Sender-Auth: 80471cf9534e8a2e X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/79 X-Sequence-Number: 26410 On 8/8/07, Nick Fankhauser wrote: > the largest containing rows. Oops- I meant to say "...the largest containing 56 million rows". One other question- when I'm vacuuming, I always get the warning: WARNING: some databases have not been vacuumed in transactions HINT: Better vacuum them within transactions, or you may have a wraparound failure. I get these even after all DBs except template0 have been freshly vacuumed. Why? -Nick