[postgis-devel] [SoC] "Gsoc weekly report 6": Implement sp-gist clustering in PostGIS and cartoDB

Sandro Santilli strk at cartodb.com
Mon Jun 30 02:36:33 PDT 2014

On Mon, Jun 30, 2014 at 12:18:23AM +0530, mohit kumar wrote:

> *What do I plan on doing next week?*
> Work on building the storage type for access method "sp-gist"

Mohit, the storage type you don't have to "build" it.
All types are built, you only have to specify which
type has to be used by the operatoc class.

The problem you were having is that you tried to use
a storage type of "box2df" while associating the opclass
to the type "geometry". The error message told you this
mixing of types is not supported by the "spgist" access
method. So you just have to pick one type and use it for
both storage type and target type.

Picking "geometry" would make the index bigger.
Picking anything else would make usage a bit convoluted as you
would not be able to index a "geometry" column but you'd have
to index the output of a function applied to it, returning the
choosed type.

I'd go with "box2df" for a start.


 ()  ASCII ribbon campaign  --  Keep it simple !
 /\  http://strk.keybit.net/rants/ascii_mails.txt  

More information about the postgis-devel mailing list