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-owner@postgresql.org [pgsql-general-owner@postgresql.org] per conto di Job [Job@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
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