[postgis-users] Partitioning spatial table

[Markus Schaber]

Hi, Paul,

Paul Ramsey wrote:

> They do, but both components have to be GiST.  So if you want an  index
> ( geometry, integer ) you need a GiST index for integers.   There are
> btree-gist implementations in ./contrib of pgsql, but not  necessarily
> for all data types.  The other note is that I have yet to  hear of
> anyone really getting a great performance boost from this  approach, but
> I will wait and hope to be surprised.

I'd try (integer, geometry) instead of (geometry, integer) in this case,
but as the integer has so few distinct values, partial indices will be
better.

HTH,
Markus


-- 
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org