[postgis-users] Fun with multikey GiST

[Paul Ramsey]

I am disappointed that the multikey GiST was not more effective. I would
have hoped it would return results just as fast as pure geometric
queries. One possibility for multidimensional searching is generalizing
the RTree index we are using to operate in 3-space. That way one could
index features pseudo geometrically, with the Z value standing in for
some other parameter. A ways away though...

P.

Andy Turk wrote:
> 
> I was hoping for another order of magnitude speedup with the multikey index,
> but maybe that was too ambitious. I suspect that I'll have to do something
> more clever than just hashing on street names to get that level of
> performance.

-- 
      __
     /
     | Paul Ramsey
     | Refractions Research
     | Email: pramsey at refractions.net
     | Phone: (250) 885-0632
     \_