Re: [PATCH] Microvacuum for gist.

Поиск
Список
Период
Сортировка
От Teodor Sigaev
Тема Re: [PATCH] Microvacuum for gist.
Дата
Msg-id 55EEB57E.3080709@sigaev.ru
обсуждение исходный текст
Ответ на Re: [PATCH] Microvacuum for gist.  (Anastasia Lubennikova <a.lubennikova@postgrespro.ru>)
Ответы Re: [PATCH] Microvacuum for gist.  (Teodor Sigaev <teodor@sigaev.ru>)
Список 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/
 



В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Shulgin, Oleksandr"
Дата:
Сообщение: Re: On-demand running query plans using auto_explain and signals
Следующее
От: Teodor Sigaev
Дата:
Сообщение: Re: [PATCH] Microvacuum for gist.