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