Re: One source of constant annoyance identified - Mailing list pgsql-general

"Markus Wollny" <Markus.Wollny@computec.de> writes:
>                 lower(MESSAGE.TEXT) like '%ich%'
>             or    lower(MESSAGE.TEXT) like 'ich%'
>             or    lower(MESSAGE.TEXT) like '%ich'

Is whoever wrote this under the misimpression that % can't match zero
characters?  You could reduce the number of LIKE tests by a factor of 3,
because the foo% and %foo tests are completely redundant.

But, back to the problem at hand --- it seems like a fair bet that
we must have a memory leak in lower() or LIKE or both.  Did you build
with locale or multibyte (or both) enabled?  If so, what locale and
what database encoding are you using, respectively?

            regards, tom lane