[postgis-devel] 3D spatial index is not working

Jose Carlos Martinez Llario jomarlla at cgf.upv.es
Thu Dec 29 12:54:32 PST 2011


Dear PostGIS team,

p3d is a table with points in 3d and an spatial index on geom.
Explain analyze shows 3d spatial index is not working.  I forced 
PostgreSQL to use index with SET enable_seqscan = false just in case.

r8612-1=# explain analyze select count(*) from p3d where geom &&& 
'LINESTRING (690388.797 4369343.266 600,690906.097 4369841.766 
600.5)'::geometry;
QUERY PLAN
Aggregate  (cost=10000002117.72..10000002117.73 rows=1 width=0) (actual 
time=54.430..54.431 rows=1 loops=1)
   ->  Seq Scan on p3d  (cost=10000000000.00..10000002117.50 rows=87 
width=0) (actual time=0.041..53.394 rows=2148 loops=1)
         Filter: (geom &&& 
'0102000080020000004E621098A9112541DD2406D1EFAA50410000000000C08240E7FBA931B4152541DD2406716CAB50410000000000C48240'::geometry)

Has PostGIS 2.0 already implemented 3d spatial index right?
What Im doing wrong then?

Im using trunk r8612.

Thanks in advance,
Best,
Jose




More information about the postgis-devel mailing list