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