<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EstiloCorreo17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@page Section1
{size:595.3pt 841.9pt;
margin:70.85pt 3.0cm 70.85pt 3.0cm;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=ES link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'>Hi,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'>I’m having some problems with the GeomUnion
(geometry, geometry) function- basically that it takes forever and eventually
crashes out for lack of memory. <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'>I’m trying to perform a union on two polygon
tables (of 9,000 and 200 rows respectively), which are indexed on the geometry
column, and vacuumed too. The command I’m trying to run is: <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'>SELECT <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'>
table1.name AS t1_name,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'>
table2.name AS t2_name,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'>
GeomUnion(table1.the_geom, table2.the_geom) <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'>INTO<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'>
table_union<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'>FROM <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'>
table1, table2;<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'>From what I can gather, it shouldn’t be that
demanding. In Kosmo the same operation takes less than 30 seconds (although it
only lets you maintain the attributes from one of the tables). Is it just that
the function takes a very long time or should I perform other functions before
carry out the GeomUnion??<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'>All help greatly appreciated!!<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'>Matt<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<table class=MsoNormalTable border=0 cellpadding=0 align=left width="100%"
bgcolor=white style='width:100.0%;background:white'>
<tr>
<td colspan=2 style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal style='mso-element:frame'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'> <o:p></o:p></span></font></p>
</td>
</tr>
<tr>
<td colspan=2 style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal style='mso-element:frame'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'> <o:p></o:p></span></font></p>
</td>
</tr>
<tr>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal style='mso-element:frame'><font size=3 color="#2e3a75"
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:#2E3A75'>Matt
Doughty</span></font><o:p></o:p></p>
</td>
<td rowspan=5 valign=top style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal style='mso-element:frame'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'><img width=90
height=100 id="_x0000_i1025" src="cid:image001.jpg@01C7A434.8ACFB030"><o:p></o:p></span></font></p>
</td>
</tr>
<tr>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal style='mso-element:frame'><font size=3 color="#2e3a75"
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:#2E3A75'>GEOGRAMA
S.L.</span></font><font face=Arial><span style='font-family:Arial'><o:p></o:p></span></font></p>
</td>
</tr>
<tr>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal style='mso-element:frame'><font size=3 color="#2e3a75"
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:#2E3A75'>Tel.:
+34 945 13 13 72 652 77 14 15</span></font><font face=Arial><span
style='font-family:Arial'><o:p></o:p></span></font></p>
</td>
</tr>
<tr>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal style='mso-element:frame'><font size=3 color="#2e3a75"
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:#2E3A75'>Fax:
+34 945 23 03 40 </span></font><font face=Arial><span style='font-family:
Arial'><o:p></o:p></span></font></p>
</td>
</tr>
<tr>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal style='mso-element:frame'><font size=3 color="#2e3a75"
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:#2E3A75'>www.geograma.com</span></font><font
face=Arial><span style='font-family:Arial'><o:p></o:p></span></font></p>
</td>
</tr>
<tr>
<td colspan=2 style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal style='mso-element:frame'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'> <o:p></o:p></span></font></p>
</td>
</tr>
</table>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
</div>
</body>
</html>