| 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/
| 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 |