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. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers