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


---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

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.

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQFGa/Y8IB7bNG8LQkwRAiLvAJ9m1aUVPXMRCEcvWu7cQ7o12nkkZACg h1Mp
A217sBifyGKKABclYqIMzNU=
=Nc5g
-----END PGP SIGNATURE-----