Re: vacuumdb runtime - Mailing list pgsql-general

From Tom Lane
Subject Re: vacuumdb runtime
Date
Msg-id 8832.990478425@sss.pgh.pa.us
Whole thread Raw
In response to vacuumdb runtime  ("Randall F. Kern" <randy@spoke.net>)
List pgsql-general
"Randall F. Kern" <randy@spoke.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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: vacuumdb runtime
Next
From: Justin Clift
Date:
Subject: Re: how to install postgresql