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

From: zhangjinyu <beijing_pg(at)163(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: BRIN Scan: Optimize memory allocation in function 'bringetbitmap'
Date: 2015-09-29 23:01:56
Message-ID: 1443567716304-5867980.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I forgot disable-c-assert last test.
The following show the test result when disable-c-assert.
After optimize code (warm run)
postgres=# select count(*) from lineitem where l_orderkey=1;
count
-------
6
(1 row)

Time: 327.143 ms
Before optimizing code (warm run)
postgres=# select count(*) from lineitem where l_orderkey=1;
count
-------
6
(1 row)

Time: 404.323 ms

Here is the patch.
patch_optimize_mem.patch_optimize_mem
<http://postgresql.nabble.com/file/n5867980/patch_optimize_mem.patch_optimize_mem>

Jinyu Zhang

--
View this message in context: http://postgresql.nabble.com/BRIN-Scan-Optimize-memory-allocation-in-function-bringetbitmap-tp5867536p5867980.html
Sent from the PostgreSQL - hackers mailing list archive at Nabble.com.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2015-09-30 00:11:36 Re: Add pg_basebackup single tar output format
Previous Message Tom Lane 2015-09-29 22:46:11 Re: No Issue Tracker - Say it Ain't So!