Postgres Pro
Downloads
Home   >   mailing lists

Re: How to create an index for type timestamp column using rtree? - Mailing list pgsql-performance

From Tom Lane
Subject Re: How to create an index for type timestamp column using rtree?
Date
Msg-id 11800.1089699297@sss.pgh.pa.us
Whole thread Raw
In response to How to create an index for type timestamp column using rtree?  (Chris Cheston <ccheston@gmail.com>)
List pgsql-performance
Tree view 
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 by date:

Previous
From: Chris Cheston
Date:
Subject: How to create an index for type timestamp column using rtree?
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: How to create an index for type timestamp column using