I tried to create a GIST/GIN index on a timestamp without time zone field but it does not work. Are there alternatives index types or timezone could speed query up?
Thank you /F ________________________________ Da: pgsql-general-ow...@postgresql.org [pgsql-general-ow...@postgresql.org] per conto di Job [j...@colliniconsulting.it] Inviato: venerdì 30 dicembre 2016 10.55 A: David G. Johnston Cc: pgsql-general@postgresql.org Oggetto: R: [GENERAL] 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.g.johns...@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 <j...@colliniconsulting.it<mailto:j...@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 https://www.postgresql.org/docs/9.6/static/pgtrgm.html https://www.postgresql.org/docs/9.6/static/btree-gist.html David J.
