VACUUM WARNING: skipping

From: Ray Stell <stellr(at)cns(dot)vt(dot)edu>
To: pgsql-admin(at)postgresql(dot)org
Subject: VACUUM WARNING: skipping
Date: 2009-08-13 15:09:10
Message-ID: 20090813150910.GA18704@cns.vt.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

PostgreSQL 8.2.9 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-9)
with autovacuum = on

I'm getting these warnings:

2009-08-12 10:36:24 EDT,5509339,VACUUM WARNING: skipping "sql_sizing_profiles" --- only table or database owner can vacuum it

for various information_schema and pg_catalog objects. For example:

sql_sizing
sql_features
sql_implementation_info
pg_database

I ran vacuum verbose by hand and it did seem to work on these guys:

INFO: vacuuming "pg_catalog.pg_database"
INFO: "pg_database": found 0 removable, 4 nonremovable row versions in 1 pages
DETAIL: 0 dead row versions cannot be removed yet.
Nonremovable row versions range from 128 to 176 bytes long.
There were 3 unused item pointers.
Total free space (including removable row versions) is 7536 bytes.
0 pages are or will become empty, including 0 at the end of the table.
1 pages containing 7536 free bytes are potential move destinations.
CPU 0.00s/0.00u sec elapsed 0.00 sec.

Suggested action?

Browse pgsql-admin by date

  From Date Subject
Next Message Kevin Grittner 2009-08-13 18:11:50 Re: Space usage
Previous Message Tom Lane 2009-08-13 14:59:11 Re: "Too many open files in system" error