[postgis-users] PosGis shutdown with request using within

[Xavier Mauclaire]

Hi
 
i'm using the folowing request to calculate the numbre ob buildings in
classified polygones the request is
 <mailto:postgis-users at postgis.refractions.net>  
SELECT r.code_reg, count(*)
FROM batiments  p, zonage_reglementaire r
WHERE 
r.wkb_geometry && p.wkb_geometry and within(p.wkb_geometry, r.wkb_geometry)
group by r.code_reg
 
This request usually works well but in some case  (more the 10000 building
and 350 polygons in the second layer)  this query shutdowns the postmaster
service and sometimes, more annoyingly, it makes the server no more usable
and the only thing to do is to do a hard reset.
 
Any help will be appreciated
 
Postgresql version 8.1.3
Postgis Version 1.1.1
Geos version 2.2.1
 
regards 
 

-----------------------------------------

Xavier Mauclaire

Service informatique
GEOTER SAS
3, rue Jean Monnet
34830 Clapiers France
Tél.: +33 (0)4.67.59.18.11
Fax: +33 (0)4.67.59.18.24 

Email: xavier.mauclaire at geoter.fr

Web site: http://www.geoter.fr

-------------------------------------------------------


 

 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20061002/4ccf0ced/attachment.html>