<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2963" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=796524312-02102006><FONT face=Arial
size=2>Hi</FONT></SPAN></DIV>
<DIV><SPAN class=796524312-02102006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=796524312-02102006><FONT face=Arial size=2>i'm using the
folowing request to calculate the numbre ob buildings in classified polygones
the request is</FONT></SPAN></DIV>
<DIV><SPAN class=796524312-02102006><FONT face=Arial size=2></FONT><A
href="mailto:postgis-users@postgis.refractions.net"><FONT
color=#000066></FONT></A></SPAN> </DIV>
<DIV><FONT face=Arial size=2>SELECT r.code_reg, count(*)<BR>FROM batiments
p, zonage_reglementaire r<BR>WHERE <BR>r.wkb_geometry && p.wkb_geometry
and within(p.wkb_geometry, r.wkb_geometry)<SPAN class=796524312-02102006>
</SPAN>group by r.code_reg</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><SPAN class=796524312-02102006><FONT face=Arial size=2>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.</FONT></SPAN></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN class=796524312-02102006>Any help will
be appreciated</SPAN></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN
class=796524312-02102006></SPAN></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN class=796524312-02102006>Postgresql
version 8.1.3</SPAN></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN class=796524312-02102006>Postgis
Version 1.1.1</SPAN></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN class=796524312-02102006>Geos version
2.2.1</SPAN></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN
class=796524312-02102006></SPAN></FONT></FONT> </DIV>
<DIV><FONT><SPAN class=796524312-02102006></SPAN><FONT face=Arial><FONT
size=2><SPAN
class=796524312-02102006>regards</SPAN> </FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV class=Section1>
<P class=MsoNormal align=left><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">-----------------------------------------</SPAN></P>
<P class=MsoNormal><STRONG><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Xavier Mauclaire</SPAN></STRONG></P>
<P class=MsoNormal><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Service
informatique<BR></SPAN><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><STRONG>GEOTER SAS<BR></STRONG>3,
rue Jean Monnet<BR>34830 Clapiers France<BR><B>Tél.:</B> +33
(0)4.67.59.18.11<BR><B>Fax: </B>+33 (0)4.67.59.18.24 <?xml:namespace prefix = o
ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p></SPAN></P>
<P style="MARGIN: 0cm 0cm 0pt"><B><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Email: </SPAN></B><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><A title=mailto:Emaildestinataire
href="mailto:xavier.mauclaire@geoter.fr">xavier.mauclaire@geoter.fr</A><o:p></o:p></SPAN></P>
<P style="MARGIN: 0cm 0cm 0pt; WORD-SPACING: 0px"><B><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Web site:</SPAN></B><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> <SPAN
style="COLOR: blue">http://www.geoter.fr</SPAN><o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">-------------------------------------------------------</SPAN></P>
<P class=MsoNormal><BR> </P></DIV>
<DIV> </DIV></BODY></HTML>