Re: Question: consolidating strpos searches?

2025-01-15 Thread James Addison
On Sat, 4 Jan 2025 at 19:04, Greg Sabino Mullane wrote: > > 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

Question: consolidating strpos searches?

2025-01-04 Thread James Addison
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