<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="color: rgb(0, 0, 0); font-family: Calibri,Helvetica,sans-serif; font-size: 12pt;">
Eric,</div>
<div style="color: rgb(0, 0, 0); font-family: Calibri,Helvetica,sans-serif; font-size: 12pt;">
<br>
</div>
<div style="color: rgb(0, 0, 0); font-family: Calibri,Helvetica,sans-serif; font-size: 12pt;">
Unfortunately your suggestion did not yield any performance difference. </div>
<div style="color: rgb(0, 0, 0); font-family: Calibri,Helvetica,sans-serif; font-size: 12pt;">
<br>
</div>
<div style="color: rgb(0, 0, 0); font-family: Calibri,Helvetica,sans-serif; font-size: 12pt;">
Kind regards, Lars<br>
</div>
<hr tabindex="-1" style="width: 98%; display: inline-block;">
<div id="divRplyFwdMsg" dir="ltr"><font color="#000000" face="Calibri, sans-serif" style="font-size: 11pt;"><b>Fra:</b> Éric Lemoine <eric.lemoine@oslandia.com><br>
<b>Sendt:</b> fredag 1. juni 2018 13.28<br>
<b>Til:</b> Lars; pgpointcloud@lists.osgeo.org<br>
<b>Emne:</b> Re: [pgpointcloud] Patch min and max</font>
<div> </div>
</div>
<div class="BodyFragment"><font size="2"><span style="font-size: 11pt;">
<div class="PlainText">On Thu, 2018-05-31 at 13:46 +0000, Lars wrote:<br>
> Hello,<br>
> <br>
> The below query takes 1,46 seconds using table with 50 000 patches<br>
> and at least 5 seconds using table with 160 000 patches.<br>
> "select id, PC_PatchMin(pa, 'x'), PC_PatchMax(pa,<br>
> 'x'),PC_PatchMin(pa, 'y'), PC_PatchMax(pa, 'y') from importdata;"<br>
<br>
<br>
If you also use PostGIS you can try the following query:<br>
<br>
select st_xmin(e.geom), st_xmax(e.geom),<br>
st_ymin(e.geom), st_ymax(e.geom)<br>
from importdata, pc_envelopegeometry(importdata.pa) e(geom);<br>
<br>
I have hope that it is more effective.<br>
<br>
<br>
-- <br>
Éric Lemoine<br>
Oslandia<br>
+33 1 86 95 95 55</div>
</span></font></div>
</body>
</html>