* Alan Cunnane ([EMAIL PROTECTED]) wrote:
> Hi Steven as requested here are the table definitions and constraints:
[...]
> Perhaps you can decipher what would be causing such a large performace 
> problem from these constraints? Any help would be much appreciated as im at 
> the end of my tether at this stage and really dont know what to do

Have you tried the bounding box addition I suggested?  Also, what about
the whole explain analyze of the query?  Perferrably with the bounding
box included?

        Thanks,

                Stephen

Attachment: signature.asc
Description: Digital signature

_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users

Reply via email to