Re: [PERFORM] substring index what is better way to query

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [PERFORM] substring index what is better way to query
Дата
Msg-id 3969.1497969947@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [PERFORM] substring index what is better way to query  (Tieson Molly <tvmaly@gmail.com>)
Список pgsql-performance
Дерево обсуждения 
Tieson Molly <tvmaly@gmail.com> writes:
> is there a different construct than the Similar To that would work?

> I know for certain that the first few characters could be different due to
> the nature of geohashes.  So I may not be able to optimize the prefix
> aspect in some cases.

Depending on what patterns you're looking for, it's possible that a
trigram index (contrib/pg_trgm) would work better.

            regards, tom lane

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

Предыдущее
От: Tieson Molly
Дата:
Сообщение: Re: [PERFORM] substring index what is better way to query
Следующее
От: Sumeet Shukla
Дата:
Сообщение: [PERFORM] Dataset is fetched from cache but still takes same time to fetchrecords as first run