"Randall F. Kern" <randy(at)spoke(dot)net> writes:
> After giving me several 'NOTICE: Skipping "pg_foo" -- only table owner
> can VACUUM it' messages, it's been running along for the last 2 hours.
> No postgres processes appear very high in "top", and the data directory
> is about 100MB.
Seems unlikely that vacuum is actually doing anything, if you can't see
it in 'top'. Perhaps it is sitting waiting to acquire a lock on some
table --- do you have any other open transactions?
regards, tom lane