On Sat, Jan 4, 2025 at 12:16 PM James Addison wrote:
> In the context of considering writing a patch: would the complexity of
> implementing such a feature for PostgreSQL be worth the potential
> performance benefits?
Probably not. As Tom said, this sounds like it should be tried as an
extensio
James Addison writes:
> In other words: each additional strpos(value, ...) expression
> increased the evaluation time by a similar, significant duration of
> two seconds. This seems to confirm the basis that each expression is
> currently evaluated separately, by an independent read from the inpu
Hello and Happy New Year,
I'd like to validate or reject a performance-related PostgreSQL patch
idea, regarding multiple strpos calls that operate on a common text
input.
>From local testing using PGSQL 17.2, and searching the mailing lists,
my understanding is that each function expression (incl
