Postgres Pro
Downloads
Home   >   mailing lists

Re: Range contains element filter not using index of the element column - Mailing list pgsql-general

From Lauri Kajan
Subject Re: Range contains element filter not using index of the element column
Date
Msg-id CAKWoFMJuPWy1gQognzhirQEACiwviM7fL-JFPGb_VKqnumjiwA@mail.gmail.com
Whole thread Raw
In response to Range contains element filter not using index of the element column  (Lauri Kajan <lauri.kajan@gmail.com>)
Responses Re: Range contains element filter not using index of the elementcolumn  (Joe Conway <mail@joeconway.com>)
List pgsql-general
Tree view
On Wed, Nov 27, 2019 at 1:05 PM Игорь Выскорко <vyskorko.igor@yandex.ru> 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 

pgsql-general by date:

Previous
From: Игорь Выскорко
Date:
Subject: Re: Range contains element filter not using index of the element column
Next
From: Joe Conway
Date:
Subject: Re: Range contains element filter not using index of the elementcolumn