Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id A94C263285F for ; Fri, 12 Feb 2010 13:02:27 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 87351-07 for ; Fri, 12 Feb 2010 17:02:17 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from locust.cns.vt.edu (locust.cns.vt.edu [198.82.169.14]) by mail.postgresql.org (Postfix) with ESMTP id 39CA16325D4 for ; Fri, 12 Feb 2010 13:02:17 -0400 (AST) Received: by locust.cns.vt.edu (Postfix, from userid 986) id 4FCAE118A74; Fri, 12 Feb 2010 12:02:16 -0500 (EST) Date: Fri, 12 Feb 2010 12:02:16 -0500 From: Ray Stell To: pgsql-admin@postgresql.org Subject: Re: VACUUM WARNING: skipping "pg_statistic" --- only table or database owner can vacuum it Message-ID: <20100212170216.GA1118@cns.vt.edu> References: <20100130145936.GA12509@cns.vt.edu> <20100209223952.GA11857@cns.vt.edu> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20100209223952.GA11857@cns.vt.edu> User-Agent: Mutt/1.5.17 (2007-11-01) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5 tests=BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 201002/109 X-Sequence-Number: 33712 On Tue, Feb 09, 2010 at 05:39:52PM -0500, Ray Stell wrote: > On Sat, Jan 30, 2010 at 09:59:36AM -0500, Ray Stell wrote: > > Is autovacuum handing all users off to vacuum all rels? Even those > it does not own? Perhaps "admin" an unfortunate usename choice? doh...the light comes on. reading through postinit.c and others makes it clear autovacuum is not the source of the vacuum. No doubt the app, Cisco Fabric Manager Server, is doing something stupid. Yep: /var/local/cisco_mds9000 # strings ./jboss/server/default/deploy/dcm.ear/dcm.jar/com/cisco/dcbu/sm/server/db/PostgresWrapper.class | grep -i vacuum vacuum_analyze vacuum analyze vacuum_analyze failed: 2. Irrelephant Anything that is unrelated to an elephant. http://www.urbandictionary.com/define.php?term=irrelephant