Re: Special-case executor expression steps for common combinations

Andreas Karlsson <andreas@proxel.se>

From: Andreas Karlsson <andreas@proxel.se>

To: Daniel Gustafsson <daniel@yesql.se>

Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>, Andres Freund <andres@anarazel.de>

Date: 2024-07-22T21:25:07Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Add special case fast-paths for strict functions
- d35d32d7112b 18.0 landed
Replace EEOP_DONE with special steps for return/no return
- 8dd7c7cd0a26 18.0 landed

I have bench marked the two patches now and failed to measure any 
speedup or slowdown from the first patch (removing return) but I think 
it is a good idea anyway.

For the second patch (optimize strict) I managed to measure a ~1% speed 
up for the following query "SELECT sum(x + y + 1) FROM t;" over one 
million rows.

I would say both patches are ready for committer modulo my proposed 
style fixes.

Andreas