Обсуждение: pgsql: Don't generate EEOP_*_FETCHSOME operations for slots know to be

Поиск
Список
Период
Сортировка

pgsql: Don't generate EEOP_*_FETCHSOME operations for slots know to be

От
Andres Freund
Дата:
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

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/36d22dd95bc87ca68e742da91f47f8826f8758c9

Modified Files
--------------
src/backend/executor/execExpr.c       |  43 +++++++----
src/backend/executor/execExprInterp.c | 133 +++++++++++++++++++++++++++++++++-
src/backend/jit/llvm/llvmjit_expr.c   |   6 +-
3 files changed, 160 insertions(+), 22 deletions(-)