From: | Chris Cheston <ccheston(at)gmail(dot)com> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: How to create an index for type timestamp column using rtree? |
Date: | 2004-07-13 07:56:02 |
Message-ID: | e071108e04071300564c0c5379@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Thanks, Chris and Tom.
I had read *incorrectly* that rtrees are better for <= and >= comparisons.
Chris
On Tue, 13 Jul 2004 14:33:48 +0800, Christopher Kings-Lynne
<chriskl(at)familyhealth(dot)com(dot)au> wrote:
> > I'm storing some timestamps as integers (UTF) in a table and I want to
> > query by <= and >= for times between a certain period. The table has
> > gotten quite large and is now very slow in querying.
> >
> > I think it's time to create an index for the timestamp column.
>
> Uh, yeah.
>
> > I tried using an rtree (for <= and >= optimization):
>
> Bad idea.
>
> > Do I have to create an rtree type for my timestamp integer column?
>
> Why do you want an rtree index? They're for multidimensional polygonal
> data and stuff. Just create a normal index...
>
> Chris
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Bill Chandler | 2004-07-13 16:13:46 | Re: [PERFORM] Cursors performance |
Previous Message | Christopher Kings-Lynne | 2004-07-13 06:33:48 | Re: How to create an index for type timestamp column using |