Re: [PATCH] Microvacuum for gist.

Поиск
Список
Период
Сортировка
От Thom Brown
Тема Re: [PATCH] Microvacuum for gist.
Дата
Msg-id CAA-aLv5w3TU33qGK8xiGSgctKnJQd1rObie=jhBD7v8dY9RagA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [PATCH] Microvacuum for gist.  (Anastasia Lubennikova <a.lubennikova@postgrespro.ru>)
Список pgsql-hackers
Дерево обсуждения
On 8 September 2015 at 22:35, Anastasia Lubennikova <a.lubennikova@postgrespro.ru> wrote:

Fixed patch is attached.

08.09.2015 13:47, Teodor Sigaev:
BTW, I slightly modify your test to provide more stable results.

 Thank you, I tried it, Results are nearly the same.

Without microvacuum
Time: 312,955 ms
Time: 264,597 ms
Time: 243,286 ms
Time: 243,679 ms

With microvacuum:
Time: 354,097 ms
Time: 82,206 ms
Time: 11,714 ms
Time: 11,277 ms

Looks good to me (except for the initial hit):

Without microvacuum: 1st run | 2nd run
Time: 259.996 ms | 246.831 ms
Time: 169.820 ms | 169.501 ms
Time: 176.045 ms | 166.845 ms
Time: 169.230 ms | 167.637 ms

With microvacuum: 1st run | 2nd run
Time: 625.883 ms | 425.231 ms
Time: 10.891 ms | 10.603 ms
Time: 10.002 ms | 10.971 ms
Time: 11.613 ms | 11.643 ms

--
Thom

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

Предыдущее
От: Anastasia Lubennikova
Дата:
Сообщение: Re: [PATCH] Microvacuum for gist.
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Proposal: Implement failover on libpq connect level.