Re: btree_gin and ranges

Поиск
Список
Период
Сортировка
От Marti Raudsepp
Тема Re: btree_gin and ranges
Дата
Msg-id CABRT9RBLZUKmeUa1twyHZ5O0Jc5zuyv_GxLGH+048EF_1BOjAg@mail.gmail.com
обсуждение исходный текст
Ответ на btree_gin and ranges  (Teodor Sigaev <teodor@sigaev.ru>)
Ответы Re: btree_gin and ranges
Список pgsql-hackers
Hi

On Wed, Oct 22, 2014 at 1:55 PM, Teodor Sigaev <teodor@sigaev.ru> wrote:
> With patch it's possible to rewrite query with ranges
> SELECT * FROM test_int4 WHERE i <@ '[-1, 1]'::int4range
> and GIN index will support this query with single scan from -1 to 1.

Shouldn't this be implemented in a more generic manner? An ordinary
btree index could very well support <@ queries too, but your patch
only adds this capability to btree-gin.

The documentation describes btree-gin as providing "GIN operator
classes that implement B-tree equivalent behavior", but now the
behavior diverges.

Regards,
Marti



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

Предыдущее
От: Teodor Sigaev
Дата:
Сообщение: btree_gin and ranges
Следующее
От: Teodor Sigaev
Дата:
Сообщение: speedup tidbitmap patch: cache page