Re: Inlining of functions (doing LIKE on an array)

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: Inlining of functions (doing LIKE on an array)
Дата
Msg-id CAMkU=1w+QQofiijZgHziYxhXjz6CNm_CDkRN_Wqif5ijQT6qjQ@mail.gmail.com
обсуждение исходный текст
Ответ на Inlining of functions (doing LIKE on an array)  ("ldh@laurent-hasson.com" <ldh@laurent-hasson.com>)
Список pgsql-performance
Дерево обсуждения
On Thu, Nov 10, 2016 at 10:54 PM, ldh@laurent-hasson.com <ldh@laurent-hasson.com> wrote:

Hello,

 

I am trying to implement an efficient “like” over a text[]. I see a lot of people have tried before me and I learnt a lot through the forums.


Have you looked at parray_gin?


(Also on PGXN, but I don't know how up-to-date it is there)

Or you could create an regular pg_trgm index on the expression:

array_to_string("ICD9_DGNS_CD",'<some safe delimiter>')

If you can find a safe delimiter to use (one that can't be part of the text[]).

The performance of these options will depend on both the nature of your data and the nature of your queries.

Cheers,

Jeff

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