Skip site navigation (1) Skip section navigation (2)

Re: VACUUM WARNING: skipping "pg_statistic" --- only tableor database owner can vacuum it

From: Ray Stell <stellr(at)cns(dot)vt(dot)edu>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: VACUUM WARNING: skipping "pg_statistic" --- only tableor database owner can vacuum it
Date: 2010-01-30 22:04:37
Message-ID: 20100130220437.GA5669@cns.vt.edu (view raw or flat)
Thread:
Lists: pgsql-admin
On Sat, Jan 30, 2010 at 10:28:37AM -0700, Scott Marlowe wrote:
> On Sat, Jan 30, 2010 at 7:59 AM, Ray Stell <stellr(at)cns(dot)vt(dot)edu> wrote:
> > Running 8.2.15 on RHEL4 the log reports this from autovacuum along with
> > other pg_ tables:
> Make yourself the owner of the database? (i.e. alter database ...)


autovacuum is throwing these.  If I vacuum as the current owner it seems to
work:

template1=# VACUUM VERBOSE ANALYZE pg_statistic;
INFO:  vacuuming "pg_catalog.pg_statistic"
INFO:  index "pg_statistic_relid_att_index" now contains 298 row versions in 2 pages
DETAIL:  0 index row versions were removed.
0 index pages have been deleted, 0 are currently reusable.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
INFO:  "pg_statistic": found 0 removable, 298 nonremovable row versions in 9 pages
DETAIL:  0 dead row versions cannot be removed yet.
There were 2 unused item pointers.
2 pages contain useful free space.
0 pages are entirely empty.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
INFO:  vacuuming "pg_toast.pg_toast_2619"
INFO:  index "pg_toast_2619_index" now contains 0 row versions in 1 pages
DETAIL:  0 index row versions were removed.
0 index pages have been deleted, 0 are currently reusable.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
INFO:  "pg_toast_2619": found 0 removable, 0 nonremovable row versions in 0 pages
DETAIL:  0 dead row versions cannot be removed yet.
There were 0 unused item pointers.
0 pages contain useful free space.
0 pages are entirely empty.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
VACUUM


In response to

pgsql-admin by date

Next:From: Alvaro HerreraDate: 2010-01-31 01:35:27
Subject: Re: VACUUM WARNING: skipping "pg_statistic" --- only table or database owner can vacuum it
Previous:From: Scott MarloweDate: 2010-01-30 17:28:37
Subject: Re: VACUUM WARNING: skipping "pg_statistic" --- only table or database owner can vacuum it

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group