Re: [PORTS] vacuum takes too long

> > From: Bruce Momjian <maillist@candle.pha.pa.us>
>
> > > insert a few row in a table (>50000) and do
> > > delete from mytable;
> > > vacuum verbose  analyze;
> > >
> > > Why is this that slow?
> >
> > Analyze checks every column in every row.
>
> even if you only type "vacuum verbose" it takes _very_ long.
>
> I deleted _all_ records with "delete from mytable;" before.
> A drop and a new create is faster. But what is when you delete (maybe
> 100000) rows but keep 100 in the table?
>
> I use 6.4.2 on NetBSD/i486 (that box makes gets 12MBytes/sec via the
> filesystem out of the drives)

Not sure what to say.  Vacuum does take a while, and it is often faster
to drop and recreate.

--
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026