[postgis-users] Query Performance Problem

[Dirk Jesko]

Hi Mark,

I finally managed to test the suggestions and put the boundary in a 
separate table. The query time is now acceptable.

Thanks again for the suggestions,
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.
>
>  
>