Horton

Don't generate EEOP_*_FETCHSOME operations for slots know to be virtual.

Andres Freund <andres@anarazel.de>

View on postgr.es
Commit: 36d22dd95bc87ca68e742da91f47f8826f8758c9
Author: Andres Freund <andres@anarazel.de>
Date: 2019-09-30T23:06:16Z
Releases: 13.0 
Don't generate EEOP_*_FETCHSOME operations for slots know to be virtual.

That avoids unnecessary work during both interpreted execution, and
JIT compiled expression evaluation. Both benefit from fewer expression
steps needing be processed, and for interpreted execution there now is
a fastpath dedicated to just fetching a value from a virtual
slot. That's e.g. beneficial for hashjoins over nodes that perform
projections, as the hashed columns are currently fetched individually.

Author: Soumyadeep Chakraborty, Andres Freund
Discussion: https://postgr.es/m/CAE-ML+9OKSN71+mHtfMD-L24oDp8dGTfaVjDU6U+j+FNAW5kRQ@mail.gmail.com

Files

PathChange+/−
src/backend/executor/execExpr.c modified +28 −15
src/backend/executor/execExprInterp.c modified +129 −4
src/backend/jit/llvm/llvmjit_expr.c modified +3 −3

Discussion