Postgres Pro
Downloads
Home   >   mailing lists

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

From Thom Brown
Subject Re: [PATCH] Microvacuum for gist.
Date
Msg-id CAA-aLv5w3TU33qGK8xiGSgctKnJQd1rObie=jhBD7v8dY9RagA@mail.gmail.com
Whole thread Raw
In response to Re: [PATCH] Microvacuum for gist.  (Anastasia Lubennikova <a.lubennikova@postgrespro.ru>)
List pgsql-hackers
Tree view
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 by date:

Previous
From: Anastasia Lubennikova
Date:
Subject: Re: [PATCH] Microvacuum for gist.
Next
From: Robert Haas
Date:
Subject: Re: Proposal: Implement failover on libpq connect level.