Re: How to create an index for type timestamp column using rtree?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: How to create an index for type timestamp column using rtree?
Дата
Msg-id 11800.1089699297@sss.pgh.pa.us
обсуждение исходный текст
Ответ на How to create an index for type timestamp column using rtree?  (Chris Cheston <ccheston@gmail.com>)
Список pgsql-performance
Chris Cheston <ccheston@gmail.com> writes:
> I'm storing some timestamps as integers (UTF) in a table and I want to
> query by <= and >= for times between a certain period.

btree can handle range queries nicely; why do you think you need an
rtree?  rtree is for 2-dimensional datums which a timestamp is not ...

            regards, tom lane

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

Предыдущее
От: Chris Cheston
Дата:
Сообщение: How to create an index for type timestamp column using rtree?
Следующее
От: Christopher Kings-Lynne
Дата:
Сообщение: Re: How to create an index for type timestamp column using