[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 
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 &&& 

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

Im using trunk r8612.

Thanks in advance,

More information about the postgis-devel mailing list