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

[Mark Cave-Ayland]

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