Nick Bower wrote:
Try making a copy of your wastac.t_tile_geometry_old table but with a
geography instead of geometry column for border, and you should see an
improvement.
That's precisely what I showed in the original post - geography
intersecting geography column. See the table def. I was outlining in
this latter geometry example that a 9s intersection is not right and
there is a problem with geograhies.
Okay - so can we see the explain analyze output for your last query for
the geography intersecting geography case for comparison?
ATB,
Mark.
--
Mark Cave-Ayland - Senior Technical Architect
PostgreSQL - PostGIS
Sirius Corporation plc - control through freedom
http://www.siriusit.co.uk
t: +44 870 608 0063
Sirius Labs: http://www.siriusit.co.uk/labs
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
