Re: [PATCH] Microvacuum for gist. - Mailing list pgsql-hackers

Something goes wrong...

gist.c:1465:5: warning: unused variable 'minoff' [-Wunused-variable]                                minoff,
gistget.c:37:1: warning: unused function 'gistkillitems' [-Wunused-function]
gistkillitems(IndexScanDesc scan)

> Without microvacuum. All 'select' queries are executed at about same time
> Time: 360,468 ms
> Time: 243,197 ms
> Time: 238,310 ms
> Time: 238,018 ms
>
> With microvacuum. First 'select' invokes gistkillitems(). It's executed a bit
> slower than before.
> But following queries are executed significantly faster than without microvacuum.
> Time: 368,780 ms
> Time: 69,769 ms
> Time: 9,545 ms
> Time: 12,427 ms
That's perfect, but I can't reproduce that. Suppose, because of "unused function 
'gistkillitems'"

-- 
Teodor Sigaev                                   E-mail: teodor@sigaev.ru
  WWW: http://www.sigaev.ru/