Re: cube_contains and indexing

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: cube_contains and indexing
Дата
Msg-id 6737.1029632563@sss.pgh.pa.us
обсуждение исходный текст
Ответ на cube_contains and indexing  (Bruno Wolff III <bruno@wolff.to>)
Ответы Re: cube_contains and indexing  (Bruno Wolff III <bruno@wolff.to>)
Список pgsql-general
Bruno Wolff III <bruno@wolff.to> writes:
> I am playing around with the cube extension in contrib and was not able to
> get cube_contains to use an index. I was able to get (what I believe to be)
> an equivalent @ operation (cubement containment) to use indexes.
> So I am either confused about there being a @ equivalent to cube_contains
> or cube_contains should be an indexable operation but isn't (or at least
> is harder to get to use an index).

It says here (cube.sql.in) that the @ operator *is* cube_contains.
Also, AFAICT both @ and ~ (the commutator operator, cube_contained)
should be equally indexable.  Can you show us your test case?

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: Bruno Wolff III
Дата:
Сообщение: cube_contains and indexing
Следующее
От: Lee Harr
Дата:
Сообщение: Re: Permission Error when starting PostgreSQL