Re: BRIN Scan: Optimize memory allocation in function 'bringetbitmap'
| От | Simon Riggs |
|---|---|
| Тема | Re: BRIN Scan: Optimize memory allocation in function 'bringetbitmap' |
| Дата | |
| Msg-id | CANP8+jKX2xy3Cx0VGiM_vRx8sms4MWW-s-atZXCduJdKdPUrGw@mail.gmail.com обсуждение исходный текст |
| Ответ на | BRIN Scan: Optimize memory allocation in function 'bringetbitmap' ("Jinyu Zhang" <beijing_pg@163.com>) |
| Ответы |
Re: BRIN Scan: Optimize memory allocation in function
'bringetbitmap'
Re: BRIN Scan: Optimize memory allocation in function 'bringetbitmap' |
| Список | pgsql-hackers |
On 27 September 2015 at 02:15, Jinyu Zhang <beijing_pg@163.com> wrote:
--
BRIN Scan: Optimize memory allocation in function 'bringetbitmap'.
We can allocate memory for some pointer before do long loop instead of allocating
memory in long loop.
Before optimizing code (warm run)
postgres=# select count(*) from lineitem where l_orderkey=1;
count
-------
6
(1 row)
Time: 456.219 ms
After optimizing code (warm run)
postgres=# select count(*) from lineitem where l_orderkey=1;
count
-------
6
(1 row)
Time: 349.219 ms
Patch?
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
В списке pgsql-hackers по дате отправления: