Re: gist index on cube column - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: gist index on cube column
Date
Msg-id 20070610130148.GB31732@svana.org
Whole thread Raw
In response to gist index on cube column  (ABHANG RANE <arane@indiana.edu>)
List 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@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

Attachment

pgsql-general by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: How to count pairs?
Next
From: Tom Allison
Date:
Subject: When should I worry?