[postgis-users] No index usage on geography query plan?

Mark Cave-Ayland mark.cave-ayland at siriusit.co.uk
Wed May 26 05:43:58 PDT 2010

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?



Mark Cave-Ayland - Senior Technical Architect
PostgreSQL - PostGIS
Sirius Corporation plc - control through freedom
t: +44 870 608 0063

Sirius Labs: http://www.siriusit.co.uk/labs

More information about the postgis-users mailing list