Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id EA9DD6334A4 for ; Fri, 30 Jul 2010 12:39:48 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 01853-05-5 for ; Fri, 30 Jul 2010 15:39:41 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from spinlock.commandprompt.com (host-215.commandprompt.net [207.173.203.215]) by mail.postgresql.org (Postfix) with ESMTP id 38475633034 for ; Fri, 30 Jul 2010 12:39:40 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by spinlock.commandprompt.com (Postfix) with ESMTP id B9FA3348035; Fri, 30 Jul 2010 08:39:34 -0700 (PDT) X-Virus-Scanned: Debian amavisd-new at commandprompt.com Received: from spinlock.commandprompt.com ([127.0.0.1]) by localhost (spinlock.commandprompt.com.commandprompt.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id heO79kVZ7zzb; Fri, 30 Jul 2010 08:39:32 -0700 (PDT) Received: from perhan.alvh.no-ip.org (190-95-29-207.bk17-dsl.surnet.cl [190.95.29.207]) by spinlock.commandprompt.com (Postfix) with ESMTPSA id 7B533348002; Fri, 30 Jul 2010 08:39:32 -0700 (PDT) Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id 4B9B76E607; Fri, 30 Jul 2010 11:39:30 -0400 (CLT) Content-Type: text/plain; charset=UTF-8 Cc: "pgsql-admin@postgresql.org" Subject: Re: Autovacuum missing tables From: Alvaro Herrera To: Bryan Payne In-reply-to: <4C52EB72.8040904@speedfc.com> References: <4C518960.3040004@speedfc.com> <4C52E42C.8070701@speedfc.com> <4C529F7B0200002500033F00@gw.wicourts.gov> <4C52EB72.8040904@speedfc.com> Date: Fri, 30 Jul 2010 11:39:30 -0400 Message-Id: <1280504209-sup-9681@alvh.no-ip.org> User-Agent: Sup/git Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201007/218 X-Sequence-Number: 35237 Excerpts from Bryan Payne's message of vie jul 30 11:10:42 -0400 2010: > Table info (this table shows last autovacuum on 7/28): > hostname=> VACUUM ANALYZE VERBOSE hierarchy_pull; > INFO: vacuuming "public.hierarchy_pull" > INFO: "hierarchy_pull": found 0 removable, 1906 nonremovable row > versions in 78 pages > DETAIL: 0 dead row versions cannot be removed yet. Eh, this says that this table didn't need a vacuum at all (no removable rows). Maybe that's why autovacuum didn't process it? -- Álvaro Herrera The PostgreSQL Company - Command Prompt, Inc. PostgreSQL Replication, Consulting, Custom Development, 24x7 support