VACUUM WARNING: skipping

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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?

-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux