R: Special index for "like"-based query

>>GIST​
>>https://www.postgresql.org/docs/9.6/static/pgtrgm.html
>>​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(dot)g(dot)johnston(at)gmail(dot)com]
Inviato: venerdì 30 dicembre 2016 0.33
A: Job
Cc: pgsql-general(at)postgresql(dot)org
Oggetto: Re: [GENERAL] Special index for "like"-based query

On Thu, Dec 29, 2016 at 4:21 PM, Job <Job(at)colliniconsulting(dot)it<mailto:Job(at)colliniconsulting(dot)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​

https://www.postgresql.org/docs/9.6/static/pgtrgm.html

​https://www.postgresql.org/docs/9.6/static/btree-gist.html
​
David J.