Hi, On 2016-12-12 18:11:13 -0800, CK Tan wrote: > Andres,
> > dev (no jiting): > > Time: 30343.532 ms > > > dev (jiting): > > SET jit_tuple_deforming = on; > > SET jit_expressions = true; > > > > Time: 24439.803 ms > > FYI, ~20% improvement for TPCH Q1 is consistent with what we find when we > only jit expression. For Q1 I think the bigger win is JITing the transition function invocation in advance_aggregates/transition_function - that's IIRC where the biggest bottleneck lies. If you have any details about your JITing experience that you're willing to talk about ... Regards, Andres -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
