| From: | Lauri Kajan <lauri(dot)kajan(at)gmail(dot)com> |
|---|---|
| To: | Игорь Выскорко <vyskorko(dot)igor(at)yandex(dot)ru> |
| Cc: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Range contains element filter not using index of the element column |
| Date: | 2019-11-27 11:33:50 |
| Message-ID: | CAKWoFMJuPWy1gQognzhirQEACiwviM7fL-JFPGb_VKqnumjiwA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, Nov 27, 2019 at 1:05 PM Игорь Выскорко <vyskorko(dot)igor(at)yandex(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joe Conway | 2019-11-27 13:36:17 | Re: Range contains element filter not using index of the element column |
| Previous Message | Игорь Выскорко | 2019-11-27 11:05:33 | Re: Range contains element filter not using index of the element column |