One more question! Is there a safe way for me to abort it (so I can get
my machine back, and run this after work?)
Thanks!
-Randy
> -----Original Message-----
> From: Randall F. Kern
> Sent: Monday, May 21, 2001 1:03 PM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] vacuumdb runtime
>
>
> 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
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to
> majordomo@postgresql.org
>