RE: [HACKERS] vacuum timings

> -----Original Message-----
> From: owner-pgsql-hackers@postgreSQL.org
> [mailto:owner-pgsql-hackers@postgreSQL.org]On Behalf Of Bruce Momjian
> 
> 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    vc_vaconeind() is called once

>     121 seconds for vacuum after deleting a single row    vc_vaconeind() is called twice

Hmmm,vc_vaconeind() takes pretty long time even if it does little. 

>     662 seconds for vacuum after deleting the entire table
>

How about half of the rows deleted case ?
It would take longer time.

Regards.

Hiroshi Inoue
Inoue@tpf.co.jp