Postgres Pro
Downloads
Home   >   mailing lists

Re: BRIN Scan: Optimize memory allocation in function 'bringetbitmap' - Mailing list pgsql-hackers

From zhangjinyu
Subject Re: BRIN Scan: Optimize memory allocation in function 'bringetbitmap'
Date
Msg-id 1443567716304-5867980.post@n5.nabble.com
Whole thread Raw
In response to Re: BRIN Scan: Optimize memory allocation in function 'bringetbitmap'  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-hackers
Tree view 
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.

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: No Issue Tracker - Say it Ain't So!
Next
From: Michael Paquier
Date:
Subject: Re: Add pg_basebackup single tar output format