Re: Range contains element filter not using index of the element column
Lauri Kajan <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.general |
|---|---|
| Message-ID | <CAKWoFMJuPWy1gQognzhirQEACiwviM7fL-JFPGb_VKqnumjiwA@mail.gmail.com> |
On Wed, Nov 27, 2019 at 1:05 PM Игорь Выскорко <[email protected]> wrote: > Hi! > Do you use GIST index? > According to > https://www.postgresql.org/docs/12/rangetypes.html#RANGETYPES-INDEXING <@ > operator is supported: > > A GiST or SP-GiST index can accelerate queries involving these range > operators: =, &&, <@, @>, <<, >>, -|-, &<, and &> > Hi, I have understood that gist indexes can be used if the column is range type but my column is just plain timestamp. I tried actually to add gist index for the timestamp column. That was not possible without installing the btree_gist extension. But that didn't work. -Lauri