<html 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)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
h2
{margin-top:12.0pt;
margin-right:0cm;
margin-bottom:3.0pt;
margin-left:70.9pt;
text-indent:-70.9pt;
page-break-after:avoid;
mso-list:l0 level2 lfo1;
font-size:14.0pt;
font-family:Arial;
font-style:italic;}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
p.MsoPlainText, li.MsoPlainText, div.MsoPlainText
{margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
p.Titre2, li.Titre2, div.Titre2
{margin-top:32.0pt;
margin-right:1.3pt;
margin-bottom:12.0pt;
margin-left:70.9pt;
text-indent:-70.9pt;
page-break-after:avoid;
mso-list:l0 level2 lfo1;
border:none;
padding:0cm;
font-size:12.0pt;
font-family:Verdana;
font-weight:bold;}
@page Section1
{size:595.3pt 841.9pt;
margin:70.85pt 69.6pt 70.85pt 69.6pt;}
div.Section1
{page:Section1;}
/* List Definitions */
@list l0
{mso-list-id:1341272332;
mso-list-template-ids:-2004483310;}
@list l0:level1
{mso-level-text:%1;
mso-level-tab-stop:1.0cm;
mso-level-number-position:left;
margin-left:1.0cm;
text-indent:-1.0cm;}
@list l0:level2
{mso-level-style-link:"Titre 2";
mso-level-text:"%1\.%2";
mso-level-tab-stop:70.9pt;
mso-level-number-position:left;
margin-left:70.9pt;
text-indent:-70.9pt;}
@list l0:level3
{mso-level-text:"%1\.%2\.%3";
mso-level-tab-stop:70.9pt;
mso-level-number-position:left;
margin-left:70.9pt;
text-indent:-70.9pt;}
@list l0:level4
{mso-level-text:"%1\.%2\.%3\.%4";
mso-level-tab-stop:70.9pt;
mso-level-number-position:left;
margin-left:70.9pt;
text-indent:-70.9pt;}
@list l0:level5
{mso-level-text:"%1\.%2\.%3\.%4\.%5";
mso-level-tab-stop:247.05pt;
mso-level-number-position:left;
margin-left:247.05pt;
text-indent:-3.0cm;}
@list l0:level6
{mso-level-number-format:none;
mso-level-text:"";
mso-level-tab-stop:3.0cm;
mso-level-number-position:left;
margin-left:3.0cm;
text-indent:-3.0cm;}
@list l0:level7
{mso-level-number-format:none;
mso-level-text:"";
mso-level-tab-stop:3.0cm;
mso-level-number-position:left;
margin-left:3.0cm;
text-indent:-3.0cm;}
@list l0:level8
{mso-level-number-format:none;
mso-level-text:"";
mso-level-tab-stop:3.0cm;
mso-level-number-position:left;
margin-left:3.0cm;
text-indent:-3.0cm;}
@list l0:level9
{mso-level-number-format:none;
mso-level-text:"";
mso-level-tab-stop:3.0cm;
mso-level-number-position:left;
margin-left:3.0cm;
text-indent:-3.0cm;}
ol
{margin-bottom:0cm;}
ul
{margin-bottom:0cm;}
-->
</style>
</head>
<body lang=FR link=blue vlink=purple>
<div class=Section1>
<p class=MsoPlainText><font size=2 face="Courier New"><span lang=EN-US
style='font-size:10.0pt'>Hi all,<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 face="Courier New"><span lang=EN-US
style='font-size:10.0pt'><o:p> </o:p></span></font></p>
<p class=MsoPlainText><font size=2 face="Courier New"><span lang=EN-US
style='font-size:10.0pt'>The request is quite simple, something like:<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 face="Courier New"><span lang=EN-US
style='font-size:10.0pt'><o:p> </o:p></span></font></p>
<p class=MsoPlainText><font size=2 face="Courier New"><span lang=EN-US
style='font-size:10.0pt'>SELECT box2d(collect(transform(wkb_geometry,4326))) FROM
mytable<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 face="Courier New"><span lang=EN-US
style='font-size:10.0pt'><o:p> </o:p></span></font></p>
<p class=MsoPlainText><font size=2 face="Courier New"><span lang=EN-US
style='font-size:10.0pt'>Mytable contains about 100000 records of a point type
geometry. A GIST index is available for the table but it takes <b><span
style='font-weight:bold'>several minutes</span></b> on a respectable recent dual-core
with 4 Gb of RAM. <o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 face="Courier New"><span lang=EN-US
style='font-size:10.0pt'><o:p> </o:p></span></font></p>
<p class=MsoPlainText><font size=2 face="Courier New"><span lang=EN-US
style='font-size:10.0pt'>Any idea would be helpful.<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 face="Courier New"><span lang=EN-US
style='font-size:10.0pt'><o:p> </o:p></span></font></p>
<p class=MsoPlainText><font size=2 face="Courier New"><span lang=EN-US
style='font-size:10.0pt'>Thx.<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 face="Courier New"><span lang=EN-US
style='font-size:10.0pt'><o:p> </o:p></span></font></p>
<p class=MsoPlainText><font size=2 face="Courier New"><span lang=EN-US
style='font-size:10.0pt'>Marc<o:p></o:p></span></font></p>
<p class=MsoPlainText><font size=2 face="Courier New"><span lang=EN-US
style='font-size:10.0pt'><o:p> </o:p></span></font></p>
</div>
</body>
</html>