Re: Range contains element filter not using index of the element column

[Lauri Kajan <lauri.kajan@xxxxxxxxx>]

On Wed, Nov 27, 2019 at 1:05 PM Игорь Выскорко <vyskorko.igor@xxxxxxxxx> 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