[postgis-users] Massive Performance Issues

[Stephen Frost]

* 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?

	Thanks,

		Stephen
-------------- 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>