Re: BRIN Scan: Optimize memory allocation in function 'bringetbitmap'

On 27 September 2015 at 02:15, Jinyu Zhang <beijing_pg(at)163(dot)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/
<http://www.2ndquadrant.com/>
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services