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

CK Tan <cktan@vitessedata.com>

From: CK Tan <cktan@vitessedata.com>

To: Andres Freund <andres@anarazel.de>

Cc: Peter Geoghegan <pg@heroku.com>, Pg Hackers <pgsql-hackers@postgresql.org>, Heikki Linnakangas <hlinnaka@iki.fi>, Doug Doole <ddoole@salesforce.com>

Date: 2016-12-13T02:11:13Z

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

Commits

Improve performance of ExecEvalWholeRowVar.
- 2f0903ea1965 10.0 landed
Remove unreachable code in expression evaluation.
- ad46a2aa79f9 10.0 landed
Faster expression evaluation and targetlist projection.
- b8d7f053c5c2 10.0 landed
Avoid syntax error on platforms that have neither LOCALE_T nor ICU.
- 457a44487328 10.0 cited
Add configure test to see if the C compiler has gcc-style computed gotos.
- bc18126a6bcb 10.0 landed
Improve regression test coverage for TID scanning.
- be6c3d19fd45 10.0 landed
Improve expression evaluation test coverage.
- ce38949ba23a 10.0 landed
Fix two errors with nested CASE/WHEN constructs.
- f0c7b789ab12 9.6.0 cited