On Mon, Nov 28, 2016 at 3:00 PM, Dilip Kumar <dilipbal...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers