From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
---|---|
To: | ABHANG RANE <arane(at)indiana(dot)edu> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: gist index on cube column |
Date: | 2007-06-10 13:01:49 |
Message-ID: | 20070610130148.GB31732@svana.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Sat, Jun 09, 2007 at 07:40:05PM -0400, ABHANG RANE wrote:
> Hi,
> I had some doubts about the gist index on cube column. So if I have a
> column of type cube and create a gist index on it, would the index be
> on individual elements in the cube or the cube as a whole. I mean will
> a gist index on cube column improve the performance of earthdistance
> function or cube_distance function.
The index will work on any operators the index is defined to work on.
So I suggest looking at the documentation for what operators are
defined and whether they solve your problem.
Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Allison | 2007-06-10 14:43:10 | When should I worry? |
Previous Message | Timasmith | 2007-06-10 12:32:55 | how to enforce index usage with +0 |