Re: Special-case executor expression steps for common combinations

From: Andreas Karlsson <andreas(at)proxel(dot)se>
To: Daniel Gustafsson <daniel(at)yesql(dot)se>
Cc: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Andres Freund <andres(at)anarazel(dot)de>
Subject: Re: Special-case executor expression steps for common combinations
Date: 2024-07-22 21:25:07
Message-ID: fcef492d-707d-4159-a491-8d78bc0f4c55@proxel.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David G. Johnston 2024-07-22 21:33:57 Re: [PATCH] GROUP BY ALL
Previous Message Joseph Koshakow 2024-07-22 21:20:15 Re: Remove dependence on integer wrapping