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

Поиск
Список
Период
Сортировка
От Loles
Тема Optimized WHERE UPPER(name) LIKE UPPER('%p_name%')
Дата
Msg-id CA+FWGK480H3mRVsSy0xofYhvpx9W1Y_h6nGfoOh0tuE0ecJ45g@mail.gmail.com
обсуждение исходный текст
Ответы Re: Optimized WHERE UPPER(name) LIKE UPPER('%p_name%')  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Optimized WHERE UPPER(name) LIKE UPPER('%p_name%')  (Jeff Janes <jeff.janes@gmail.com>)
Re: Optimized WHERE UPPER(name) LIKE UPPER('%p_name%')  (Dan Smith <j.daniel.smith1@gmail.com>)
RE: Optimized WHERE UPPER(name) LIKE UPPER('%p_name%')  (HALAT-PRUVOT SYLVIE <sylvie.halat-pruvot@region-academique-occitanie.fr>)
Список pgsql-admin
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