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