Re: vacuum timings

Bruce Momjian <pgman@candle.pha.pa.us> writes:
> 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

> I find this quite interesting.

How long does it take to create the index on your setup --- ie,
if vacuum did a drop/create index, would it be competitive?
        regards, tom lane