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