Обсуждение: gist index on cube column

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.

Thanks
Abhang

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@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.