Horton

Re: [HACKERS] vacuum timings

Vadim Mikheev <vadim@krs.ru>

View thread
From: Vadim Mikheev <vadim@krs.ru>
To: Hiroshi Inoue <Inoue@tpf.co.jp>
Cc: Bruce Momjian <pgman@candle.pha.pa.us>, PostgreSQL-development <pgsql-hackers@postgreSQL.org>, Tom Lane <tgl@sss.pgh.pa.us>
Date: 2000-01-21T06:50:42Z
Lists: pgsql-hackers 
Hiroshi Inoue wrote:
> 
> >
> > With index on the single in4 column, I got:
> >        78 seconds for a vacuum
>                 vc_vaconeind() is called once
                                    ^^^^^^
                                    not called ?
> 
> >       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.

It reads all index leaf pages in any case...

Vadim