[postgis-users] MORE THOUGHTS ABOUT PERFORMANCE IN POSTGIS

[David Blasby]

Try running 'VACUUM ANALYSE;' on your database.

Then try this :

EXPLAIN ANAYSE SELECT GEOMETRY,C_PV,C_OCA,D_OCA,GID FROM ocas WHERE 
GEOMETRY && 'BOX3D(88034.16 3926963.056375266, 634143.4400000001 
4339164.943624733'::box3d;

It should spit out a query plan with some timming number in it.

dave