[pgpointcloud] Patch min and max

[Lars]

Eric,

Unfortunately your suggestion did not yield any performance difference.

Kind regards, Lars
________________________________
Fra: Éric Lemoine <eric.lemoine at oslandia.com>
Sendt: fredag 1. juni 2018 13.28
Til: Lars; pgpointcloud at lists.osgeo.org
Emne: Re: [pgpointcloud] Patch min and max

On Thu, 2018-05-31 at 13:46 +0000, Lars wrote:
> Hello,
>
> The below query takes 1,46 seconds using table with 50 000 patches
> and at least 5 seconds using table with 160 000 patches.
> "select id, PC_PatchMin(pa, 'x'), PC_PatchMax(pa,
> 'x'),PC_PatchMin(pa, 'y'), PC_PatchMax(pa, 'y') from importdata;"


If you also use PostGIS you can try the following query:

select st_xmin(e.geom), st_xmax(e.geom),
       st_ymin(e.geom), st_ymax(e.geom)
from importdata, pc_envelopegeometry(importdata.pa) e(geom);

I have hope that it is more effective.


--
Éric Lemoine
Oslandia
+33 1 86 95 95 55
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/pgpointcloud/attachments/20180601/421afe09/attachment.html>