vacuumdb runtime

From: "Randall F(dot) Kern" <randy(at)spoke(dot)net>
To: <pgsql-general(at)postgresql(dot)org>
Subject: vacuumdb runtime
Date: 2001-05-21 20:03:26
Message-ID: E379007FADE7104B8346218F322A8BAE4EF4@sammamish-dc.spoke.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I've been lazy and have never run vacuumdb on my development machine. I
decided today that I should, and ran:

vacuumdb --username=foo foo

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.

Anyway I can tell if it's still running/hung? Any estimates on how long
it should take?

Thanks,
-Randy

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Randall F. Kern 2001-05-21 20:10:34 RE: vacuumdb runtime
Previous Message Feite Brekeveld 2001-05-21 19:58:33 Re: Spliting a table/databases between several disks ?