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

Andres Freund <andres@anarazel.de>

View thread View on postgr.es

From: Andres Freund <andres@anarazel.de>

To: pgsql-hackers@postgresql.org

Cc: Heikki Linnakangas <hlinnaka@iki.fi>, Doug Doole <ddoole@salesforce.com>

Date: 2016-12-06T03:52:05Z

Lists: pgsql-hackers

Attachments

0001-Make-get_last_attnums-more-generic.patch.gz (application/x-patch-gzip) patch 0001
0002-More-efficient-AggState-pertrans-iteration.patch.gz (application/x-patch-gzip) patch 0002
0003-Avoid-materializing-SRFs-in-the-FROM-list.patch.gz (application/x-patch-gzip) patch 0003
0004-Allow-ROWS-FROM-to-return-functions-as-single-record.patch.gz (application/x-patch-gzip) patch 0004
0005-Basic-implementation-of-targetlist-SRFs-via-ROWS-FRO.patch.gz (application/x-patch-gzip) patch 0005
0006-Remove-unused-code-related-to-targetlist-SRFs.patch.gz (application/x-patch-gzip) patch 0006
0007-WIP-Optimize-slot_deform_tuple-significantly.patch.gz (application/x-patch-gzip) patch 0007
0008-WIP-Faster-expression-processing-and-targetlist-proj.patch.gz (application/x-patch-gzip) patch 0008
0009-WIP-Add-minimal-keytest-implementation.patch.gz (application/x-patch-gzip) patch 0009
0010-WIP-Add-configure-infrastructure-to-enable-LLVM.patch.gz (application/x-patch-gzip) patch 0010
0011-WIP-Beginning-of-a-LLVM-JIT-infrastructure.patch.gz (application/x-patch-gzip) patch 0011
0012-Heavily-WIP-JITing-of-tuple-deforming.patch.gz (application/x-patch-gzip) patch 0012
0013-WIP-ExprEval-Make-threaded-dispatch-use-a-separate-f.patch.gz (application/x-patch-gzip) patch 0013
0014-Heavily-WIP-JITed-expression-evaluation.patch.gz (application/x-patch-gzip) patch 0014
0015-Heavily-WIP-LLVM-perf-integration.patch.gz (application/x-patch-gzip) patch 0015

On 2016-12-05 19:49:55 -0800, Andres Freund wrote:
> I'm posting a quite massive series of WIP patches here, to get some
> feedback.

And here's the patches themselves - let's hope they're not too big
(after gzip'ing that is).

Andres

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