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

Поиск
Список
Период
Сортировка
От Lauri Kajan
Тема Re: Range contains element filter not using index of the element column
Дата
Msg-id CAKWoFMJuPWy1gQognzhirQEACiwviM7fL-JFPGb_VKqnumjiwA@mail.gmail.com
обсуждение исходный текст
Ответ на Range contains element filter not using index of the element column  (Lauri Kajan <lauri.kajan@gmail.com>)
Ответы Re: Range contains element filter not using index of the elementcolumn
Список pgsql-general
Дерево обсуждения
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 по дате отправления: