R: [GENERAL] Special index for "like"-based query

Поиск
Список
Период
Сортировка
От Job
Тема R: [GENERAL] Special index for "like"-based query
Дата
Msg-id 88EF58F000EC4B4684700C2AA3A73D7A08054EAEBAE8@W2008DC01.ColliniConsulting.lan
обсуждение исходный текст
Ответ на Re: [GENERAL] Special index for "like"-based query  ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы R: [GENERAL] Special index for "like"-based query
Список pgsql-general
Дерево обсуждения
>>GIST​
>>​https://www.postgresql.org/docs/9.6/static/btree-gist.html
 
I tried with a GIST-like index and queries improves a lot, thank you!
 
Furthermore, this type of index is also suitable for a timestamp query, where we can mix date and time parameters?

Thank you again!
/F
 
 
Da: David G. Johnston [david.g.johnston@gmail.com]
Inviato: venerdì 30 dicembre 2016 0.33
A: Job
Cc: pgsql-general@postgresql.org
Oggetto: Re: [GENERAL] Special index for "like"-based query

On Thu, Dec 29, 2016 at 4:21 PM, Job <Job@colliniconsulting.it> wrote:
Hello,

in Postgresql 9.6 we have a query running on a very large table based, in some cases, on a like statement:

... WHERE FIELD='CODE' OR FIELD LIKE 'CODE_%'

Which type of index can i create to speed to the search when the "like" case happens?

​GIST​

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

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: [GENERAL] Book or other resource on Postgres-local code?
Следующее
От: Job
Дата:
Сообщение: R: [GENERAL] Special index for "like"-based query