[postgis-users] Massive Performance Issues

Stephen Frost sfrost at snowman.net
Tue Jul 17 17:33:36 PDT 2007

* Alan Cunnane (alan_cunnane at yahoo.co.uk) 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?


-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: Digital signature
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20070717/79d3728f/attachment.pgp>

More information about the postgis-users mailing list