Re: WIP: Faster Expression Processing and Tuple Deforming (including JIT)

From: CK Tan <cktan(at)vitessedata(dot)com>
To: Andres Freund <andres(at)anarazel(dot)de>
Cc: Peter Geoghegan <pg(at)heroku(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>, Heikki Linnakangas <hlinnaka(at)iki(dot)fi>, Doug Doole <ddoole(at)salesforce(dot)com>
Subject: Re: WIP: Faster Expression Processing and Tuple Deforming (including JIT)
Date: 2016-12-13 02:11:13
Message-ID: CAJNt7=bYNYqvQkCbSkc_Q-vV68RZcpw5r2QYE0FEMuftzNEpTA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

Cheers,
-cktan

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2016-12-13 02:14:46 Re: WIP: Faster Expression Processing and Tuple Deforming (including JIT)
Previous Message Craig Ringer 2016-12-13 01:45:41 Re: exposing wait events for non-backends (was: Tracking wait event for latches)