Re: like/ilike improvements

Поиск
Список
Период
Сортировка
От Andrew Dunstan
Тема Re: like/ilike improvements
Дата
Msg-id 46F294F1.2080206@dunslane.net
обсуждение исходный текст
Ответ на Re: like/ilike improvements  (Andrew Dunstan <andrew@dunslane.net>)
Список pgsql-hackers

I wrote:
>
>
> I can't see an obvious way around the problem for multi-byte case - 
> lower() then requires converting to and from wchar, and I don't see a 
> way of avoiding calling lower().

There is one way we could reduce the use of lower() by up to (almost) 
50% in the common case where the pattern is a constant expression (or a 
literal, as it usually is) - cache the result of lower() on the pattern 
rather than call it for every text the pattern is being compared to. I'm 
not quite sure how to achieve that though.

Anyone have good ideas?

cheers

andrew


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Improving the Performance of Full Table Updates
Следующее
От: Tom Lane
Дата:
Сообщение: HOT is applied