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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Chris Cheston <ccheston(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: How to create an index for type timestamp column using rtree?
Date: 2004-07-13 06:14:57
Message-ID: 11800.1089699297@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Chris Cheston <ccheston(at)gmail(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Christopher Kings-Lynne 2004-07-13 06:33:48 Re: How to create an index for type timestamp column using
Previous Message Chris Cheston 2004-07-13 05:51:27 How to create an index for type timestamp column using rtree?