pgsql: Minor performance improvement for SQL-language functions. - Mailing list pgsql-committers

From Tom Lane
Subject pgsql: Minor performance improvement for SQL-language functions.
Date
Msg-id E1u5SYd-000Vjn-1T@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Minor performance improvement for SQL-language functions.

Late in the development of commit 0dca5d68d, I added a step to copy
the result tlist we extract from the cached final query, because
I was afraid that that might not last as long as the JunkFilter that
we're passing it off to.  However, that turns out to cost a noticeable
number of cycles, and it's really quite unnecessary because the
JunkFilter will not examine that tlist after it's been created.
(ExecFindJunkAttribute would use it, but we don't use that function
on this JunkFilter.)  Hence, remove the copy step.  For safety,
reset the might-become-dangling jf_targetList pointer to NIL.

In passing, remove DR_sqlfunction.cxt, which we don't use anymore;
it's confusing because it's not entirely clear which context it
ought to point at.

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/09b07c29532fe7db87cbfe1c54355cfc80291b6c

Modified Files
--------------
src/backend/executor/functions.c | 19 +++++++++++--------
1 file changed, 11 insertions(+), 8 deletions(-)


pgsql-committers by date:

Previous
From: Noah Misch
Date:
Subject: pgsql: Assert lack of hazardous buffer locks before possible catalog re
Next
From: Tom Lane
Date:
Subject: Re: pgsql: Make SQLFunctionCache long-lived again.