Re: [HACKERS] vacuum timings

> Bruce Momjian wrote:
> > 
> > I loaded 10,000,000 rows into CREATE TABLE test (x INTEGER);  Table is
> > 400MB and index is 160MB.
> > 
> > With index on the single in4 column, I got:
> >          78 seconds for a vacuum
> >         121 seconds for vacuum after deleting a single row
> >         662 seconds for vacuum after deleting the entire table
> > 
> > With no index, I got:
> >          43 seconds for a vacuum
> >          43 seconds for vacuum after deleting a single row
> >          43 seconds for vacuum after deleting the entire table
> 
> Wi/wo -F ?

With no -F.

I can get you -F times tomorrow.

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