Re: [PATCH] Microvacuum for gist.

From: Teodor Sigaev <teodor(at)sigaev(dot)ru>
To: Anastasia Lubennikova <a(dot)lubennikova(at)postgrespro(dot)ru>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [PATCH] Microvacuum for gist.
Date: 2015-09-08 10:16:30
Message-ID: 55EEB57E.3080709@sigaev.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)sigaev(dot)ru
WWW: http://www.sigaev.ru/

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Teodor Sigaev 2015-09-08 10:47:56 Re: [PATCH] Microvacuum for gist.
Previous Message Shulgin, Oleksandr 2015-09-08 09:49:36 Re: On-demand running query plans using auto_explain and signals