RE: vacuumdb runtime

From: "Randall F(dot) Kern" <randy(at)spoke(dot)net>
To: "Randall F(dot) Kern" <randy(at)spoke(dot)net>, <pgsql-general(at)postgresql(dot)org>
Subject: RE: vacuumdb runtime
Date: 2001-05-21 20:10:34
Message-ID: E379007FADE7104B8346218F322A8BAE042295@sammamish-dc.spoke.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(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
>

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Erny 2001-05-21 20:11:10 Primar keys in tables
Previous Message Randall F. Kern 2001-05-21 20:03:26 vacuumdb runtime