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