Re: WIP: index support for regexp search

Поиск
Список
Период
Сортировка
От Alexander Korotkov
Тема Re: WIP: index support for regexp search
Дата
Msg-id CAPpHfdvYtQXNm-vMXCuGGEnh4a1x_JgHV_ZFpC+8mmZnquN9ig@mail.gmail.com
обсуждение исходный текст
Ответ на Re: WIP: index support for regexp search  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-hackers
Hi!

On Wed, Nov 21, 2012 at 12:51 AM, Pavel Stehule <pavel.stehule@gmail.com> wrote:
do you plan to support GiST?

At first, I would note that pg_trgm GiST opclass is quite ridiculous for support regex search (and, actually for LIKE/ILIKE search which is already implemented too). Because in GiST opclass we store set of trigrams in leaf pages. In was designed for trigram similarity search and have sense for it because of elimination of trigram set computation. But for regex or LIKE/ILIKE search this representation is both lossy and bigger than just original string. Probably we could think about another opclass for GiST focusing on regex and LIKE/ILIKE search?

However, amyway I can create additional patch for current GiST opclass.

------
With best regards,
Alexander Korotkov.

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

Предыдущее
От: Alexander Korotkov
Дата:
Сообщение: Re: WIP: index support for regexp search
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Doc patch: Document names of automatically created constraints and indexes