Re: vacuumdb runtime

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(at)postgresql(dot)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(at)postgresql(dot)org
>

"Randall F. Kern" <randy(at)spoke(dot)net> writes:
> 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?)

Killing the process running VACUUM should work.

regards, tom lane