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