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?
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 |