RE: vacuumdb runtime - Mailing list pgsql-general

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

pgsql-general by date:

Previous
From: "Randall F. Kern"
Date:
Subject: vacuumdb runtime
Next
From: Peter Eisentraut
Date:
Subject: Re: how to install postgresql