[postgis-users] Query Performance Problem

[Mark Cave-Ayland]

> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net 
> [mailto:postgis-users-bounces at postgis.refractions.net] On 
> Behalf Of Dirk Jesko
> Sent: 28 January 2005 10:20
> To: PostGIS Users Discussion
> Subject: Re: [postgis-users] Query Performance Problem
> 
> 
> Ok, here it comes. The two queries in question and the 
> EXPLAIN ANALYZE 
> VERBOSE results are attached (test1 is the long running, test3 the 
> "normal" one). The joins are quite different. I think, that 
> especially 
> the different placement of the contains(...)-condition from 
> infogis_admin might be an issue.
> 
> Regards,
> Dirk


Hi Dirk,

Thanks for the information. I can't see anything too wrong with the query
plans, other than that some times seem quite large for the Nested Loops. I'm
still thinking it may be caused by the aggregate being used in your view;
could you try the suggestion in my previous email and see if that improves
things for you?


Kind regards,

Mark.

------------------------
WebBased Ltd
South West Technology Centre
Tamar Science Park
Plymouth
PL6 8BT 

T: +44 (0)1752 791021
F: +44 (0)1752 791023
W: http://www.webbased.co.uk

------------------------
WebBased Ltd
South West Technology Centre
Tamar Science Park
Plymouth
PL6 8BT 

T: +44 (0)1752 791021
F: +44 (0)1752 791023
W: http://www.webbased.co.uk