Optimized WHERE UPPER(name) LIKE UPPER('%p_name%')

Поиск
Список
Период
Сортировка
Hi!

A question about query optimization.

We have a simple query with several tables joined.

We have seen performance down when we use WHERE UPPER(name) LIKE UPPER('%Alice%') in the condition.

If we compare with WHERE UPPER(name) = UPPER('Alice') it runs very fast.

We have tried an index on the name field, an UPPER(name) expression index, a GIN index, etc. but nothing seems to work.

We need to optimize the condition WHERE UPPER(name) LIKE UPPER('%p_name%)

Any ideas?

Thanks!!

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

Предыдущее
От: SOzcn
Дата:
Сообщение: Re: On Replica - History issue
Следующее
От: SOzcn
Дата:
Сообщение: Re: On Replica - History issue