[postgis-users] Massive Performance Issues

Stephen Frost sfrost at snowman.net
Tue Jul 17 18:04:17 PDT 2007


* Alan Cunnane (alan_cunnane at yahoo.co.uk) wrote:
> Already the bounding box seems to be making a big difference as you can see. This is th eentire EXPLAIN output:
[...]
> Can you see anymore clues in here which would help as the performance still really needs to be a lot better than this? I really appreciate your help

Can you run the query with an 'explain analyze' so we can see where the
time is actually being spent?

Is the query generating the correct result?

	Thanks,

		Stephen

> ----- Original Message ----
> From: Stephen Frost <sfrost at snowman.net>
> To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
> Sent: Wednesday, 18 July, 2007 1:33:36 AM
> Subject: Re: [postgis-users] Massive Performance Issues
> 
> * 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
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 
> 
> 
> 
> 
> 
> 
>       ___________________________________________________________
> Yahoo! Answers - Got a question? Someone out there knows the answer. Try it
> now.
> http://uk.answers.yahoo.com/ 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

-------------- 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/39a2a743/attachment.pgp>


More information about the postgis-users mailing list