Re: Proposal: scan key push down to heap [WIP]

On Mon, Nov 28, 2016 at 3:00 PM, Dilip Kumar <dilipbalaut@gmail.com> wrote:
> As promised, I have taken the performance with TPCH benchmark and
> still result are quite good. However this are less compared to older
> version (which was exposing expr ctx and slot to heap).
>
> Query       Head             [1] Patch3               Improvement
> Q3           36122.425      32285.608         10%
> Q4           6797               5763.871           15%
> Q10        17996.104      15878.505          11%
> Q12        12399.651        9969.489          19%
>
>  [1] heap_scankey_pushdown_POC_V3.patch : attached with the mail.

I forgot to mention the configuration parameter in last mail..

TPCH-scale factor 10.
work mem 20MB
Power, 4 socket machine
Shared Buffer 1GB


-- 
Regards,
Dilip Kumar
EnterpriseDB: http://www.enterprisedb.com