<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="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt">Hi</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt"><br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt">Thanks , this was fast code update .</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt"><br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt"><span style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; background: var(--white);">Tested the code now but with geos 3.7 and the attached file and I still
have the same problem . </span></div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt"><span style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; background: var(--white);"><br>
</span></div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt"><span style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; background: var(--white);">I assume there is something related to that I tested with geos 3.7.</span><br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt"><br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt">I also had to test om another server with this cpu (<span style="font-family:Menlo; font-size:11px; font-variant-ligatures:no-common-ligatures">Intel(R) Xeon(R)
</span><span style="font-family:Menlo; font-size:11px; font-variant-ligatures:no-common-ligatures; color:rgb(255,255,255); background-color:rgb(0,0,0)">CPU</span><span style="font-family:Menlo; font-size:11px; font-variant-ligatures:no-common-ligatures"> E3-1270
V2 @ 3.50GHz (fam: 06, model: 3a, stepping: 09)</span><span style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt">) where I was running centos 7.</span></div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt">But I don't think this should make so much difference </div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt">
<div><br>
</div>
<div>Here is the test after the update on this server. </div>
<div><br>
</div>
<div>How I installed and compiled is further down the mail.</div>
<div><br>
</div>
<div>
<p style="margin-top: 0px; margin-bottom: 0px;margin:0px; font-size:11px; line-height:normal; font-family:Menlo">
<span style="font-variant-ligatures:no-common-ligatures">SELECT PostGIS_full_version();</span></p>
<p style="margin-top: 0px; margin-bottom: 0px;margin:0px; font-size:11px; line-height:normal; font-family:Menlo">
<span style="font-variant-ligatures:no-common-ligatures"> postgis_full_version
</span></p>
<p style="margin-top: 0px; margin-bottom: 0px;margin:0px; font-size:11px; line-height:normal; font-family:Menlo">
<span style="font-variant-ligatures:no-common-ligatures">----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------</span></p>
<p style="margin-top: 0px; margin-bottom: 0px;margin:0px; font-size:11px; line-height:normal; font-family:Menlo">
<span style="font-variant-ligatures:no-common-ligatures"> POSTGIS="2.5.3dev r17378" [EXTENSION] PGSQL="110" GEOS="3.7.2dev-CAPI-1.11.2 995c7c4" SFCGAL="1.2.2" PROJ="Rel. 4.8.0, 6 March 2012" GDAL="GDAL 1.11.5, released 2016/07/01" LIBXML="2.9.1" LIBJSON="0.11"
TOPOLOGY RASTER</span></p>
<div><span style="font-variant-ligatures:no-common-ligatures"><br>
</span></div>
<div><span style="font-variant-ligatures:no-common-ligatures">
<p style="margin-top: 0px; margin-bottom: 0px;margin:0px; font-size:11px; line-height:normal; font-family:Menlo">
<span style="font-variant-ligatures:no-common-ligatures">EXPLAIN ANALYZE</span></p>
<p style="margin-top: 0px; margin-bottom: 0px;margin:0px; font-size:11px; line-height:normal; font-family:Menlo">
<span style="font-variant-ligatures:no-common-ligatures">select (ST_dump(st_union(geo))).geom as geo</span></p>
<p style="margin-top: 0px; margin-bottom: 0px;margin:0px; font-size:11px; line-height:normal; font-family:Menlo">
<span style="font-variant-ligatures:no-common-ligatures">from sde_markslag.markslag_myrikilden_temp </span></p>
<p style="margin-top: 0px; margin-bottom: 0px;margin:0px; font-size:11px; line-height:normal; font-family:Menlo">
<span style="font-variant-ligatures:no-common-ligatures">where gid < 10000</span></p>
<p style="margin-top: 0px; margin-bottom: 0px;margin:0px; font-size:11px; line-height:normal; font-family:Menlo">
<br>
</p>
<p style="margin-top: 0px; margin-bottom: 0px;margin:0px; font-size:11px; line-height:normal; font-family:Menlo">
<span style="font-variant-ligatures:no-common-ligatures"></span></p>
<p style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo">
<span style="font-variant-ligatures: no-common-ligatures"> QUERY PLAN </span></p>
<p style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo">
<span style="font-variant-ligatures: no-common-ligatures">---------------------------------------------------------------------------------------------------------------------------------------------------</span></p>
<p style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo">
<span style="font-variant-ligatures: no-common-ligatures"> Result (cost=62634.10..62899.37 rows=1000 width=32) (actual time=23445.338..23544.121 rows=9205 loops=1)</span></p>
<p style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo">
<span style="font-variant-ligatures: no-common-ligatures"> -> ProjectSet (cost=62634.10..62639.37 rows=1000 width=32) (actual time=23445.333..23542.636 rows=9205 loops=1)</span></p>
<p style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo">
<span style="font-variant-ligatures: no-common-ligatures"> -> Aggregate (cost=62634.10..62634.11 rows=1 width=32) (actual time=23442.220..23442.220 rows=1 loops=1)</span></p>
<p style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo">
<span style="font-variant-ligatures: no-common-ligatures"> -> Seq Scan on markslag_myrikilden_temp (cost=0.00..62609.51 rows=9835 width=1600) (actual time=0.015..178.305 rows=9999 loops=1)</span></p>
<p style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo">
<span style="font-variant-ligatures: no-common-ligatures"> Filter: (gid < 10000)</span></p>
<p style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo">
<span style="font-variant-ligatures: no-common-ligatures"> Rows Removed by Filter: 557242</span></p>
<p style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo">
<span style="font-variant-ligatures: no-common-ligatures"> Planning Time: 0.189 ms</span></p>
<p style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo">
<span style="font-variant-ligatures: no-common-ligatures"> Execution Time: 23544.779 ms</span></p>
<p style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo">
<span style="font-variant-ligatures: no-common-ligatures">(8 rows)</span></p>
<div><span style="font-variant-ligatures: no-common-ligatures"><br>
</span></div>
<div><span style="font-variant-ligatures:no-common-ligatures"><br>
</span></div>
</span></div>
</div>
<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt">Can I use 3.7 or do I have to compile the master branch together postgis 2.5 ?</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt"><span style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt;">I was not sure about what to merge from master into 3.7. So I just picked the attached file </span><span style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt;">from </span><span style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt;">master
and nothing else..</span><br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt"><br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt"><span style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; background: var(--white);">Then I removed postgis, gets and gdal installed by yum by using yum remove.</span></div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt"><span style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; background: var(--white);"><br>
</span></div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt"><span style="background: var(--white);">Then I Downloaded and compiled : The size was <span style="background: var(--white);">521488 for ./src/operation/union/CascadedPolygonUnion.o</span><br>
</span><br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt"><br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt">gdal branch 1.1 (Why do we use this old gdal ?)</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt">geos branch 3.7 with a copy of CascadedPolygonUnion.cpp from master </div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt">postgis brach 2.5 </div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt"><br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt">
<p style="margin-top: 0px; margin-bottom: 0px;margin:0px; font-size:11px; line-height:normal; font-family:Menlo">
./configure --with-geosconfig=/home/lop/postgres_code/geos/tools/geos-config --with-pgconfig=/usr/pgsql-11/bin/pg_config<br>
</p>
<p style="margin-top: 0px; margin-bottom: 0px;margin:0px; font-size:11px; line-height:normal; font-family:Menlo">
<br>
</p>
<p style="margin-top: 0px; margin-bottom: 0px;margin:0px; font-size:11px; line-height:normal; font-family:Menlo">
Then I got this error</p>
<p style="margin-top: 0px; margin-bottom: 0px;margin:0px; font-size:11px; line-height:normal; font-family:Menlo">
</p>
<div>
<p style="margin-top: 0px; margin-bottom: 0px;margin:0px; font-size:11px; line-height:normal; font-family:Menlo">
<span style="font-variant-ligatures:no-common-ligatures">./configure: line 13475: /home/lop/postgres_code/geos/tools/geos-config: Permission denied</span></p>
<p style="margin-top: 0px; margin-bottom: 0px;margin:0px; font-size:11px; line-height:normal; font-family:Menlo">
<span style="">I added execute on that file then it compiled with ok and installed</span><br>
</p>
</div>
<div></div>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt"><br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt"><span style="">PostGIS is now configured for x86_64-unknown-linux-gnu</span><br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt">
<p style="margin-top: 0px; margin-bottom: 0px;margin:0px; font-size:11px; line-height:normal; font-family:Menlo; min-height:13px">
<span style="font-variant-ligatures:no-common-ligatures"></span><br>
</p>
<p style="margin-top: 0px; margin-bottom: 0px;margin:0px; font-size:11px; line-height:normal; font-family:Menlo">
<span style="font-variant-ligatures:no-common-ligatures"> -------------- Compiler Info ------------- </span></p>
<p style="margin-top: 0px; margin-bottom: 0px;margin:0px; font-size:11px; line-height:normal; font-family:Menlo">
<span style="font-variant-ligatures:no-common-ligatures"> C compiler: gcc -g -O2</span></p>
<p style="margin-top: 0px; margin-bottom: 0px;margin:0px; font-size:11px; line-height:normal; font-family:Menlo">
<span style="font-variant-ligatures:no-common-ligatures"> SQL preprocessor: /usr/bin/cpp -traditional-cpp -w -P</span></p>
<p style="margin-top: 0px; margin-bottom: 0px;margin:0px; font-size:11px; line-height:normal; font-family:Menlo; min-height:13px">
<span style="font-variant-ligatures:no-common-ligatures"></span><br>
</p>
<p style="margin-top: 0px; margin-bottom: 0px;margin:0px; font-size:11px; line-height:normal; font-family:Menlo">
<span style="font-variant-ligatures:no-common-ligatures"> -------------- Additional Info ------------- </span></p>
<p style="margin-top: 0px; margin-bottom: 0px;margin:0px; font-size:11px; line-height:normal; font-family:Menlo">
<span style="font-variant-ligatures:no-common-ligatures"> Interrupt Tests: DISABLED use: --with-interrupt-tests to enable</span></p>
<p style="margin-top: 0px; margin-bottom: 0px;margin:0px; font-size:11px; line-height:normal; font-family:Menlo; min-height:13px">
<span style="font-variant-ligatures:no-common-ligatures"></span><br>
</p>
<p style="margin-top: 0px; margin-bottom: 0px;margin:0px; font-size:11px; line-height:normal; font-family:Menlo">
<span style="font-variant-ligatures:no-common-ligatures"> -------------- Dependencies -------------- </span></p>
<p style="margin-top: 0px; margin-bottom: 0px;margin:0px; font-size:11px; line-height:normal; font-family:Menlo">
<span style="font-variant-ligatures:no-common-ligatures"> GEOS config: /home/lop/postgres_code/geos/tools/geos-config</span></p>
<p style="margin-top: 0px; margin-bottom: 0px;margin:0px; font-size:11px; line-height:normal; font-family:Menlo">
<span style="font-variant-ligatures:no-common-ligatures"> GEOS version: 3.7.2dev</span></p>
<p style="margin-top: 0px; margin-bottom: 0px;margin:0px; font-size:11px; line-height:normal; font-family:Menlo">
<span style="font-variant-ligatures:no-common-ligatures"> GDAL config: /usr/local/bin/gdal-config</span></p>
<p style="margin-top: 0px; margin-bottom: 0px;margin:0px; font-size:11px; line-height:normal; font-family:Menlo">
<span style="font-variant-ligatures:no-common-ligatures"> GDAL version: 1.11.5</span></p>
<p style="margin-top: 0px; margin-bottom: 0px;margin:0px; font-size:11px; line-height:normal; font-family:Menlo">
<span style="font-variant-ligatures:no-common-ligatures"> SFCGAL config: /usr/bin/sfcgal-config</span></p>
<p style="margin-top: 0px; margin-bottom: 0px;margin:0px; font-size:11px; line-height:normal; font-family:Menlo">
<span style="font-variant-ligatures:no-common-ligatures"> SFCGAL version: 1.2.2</span></p>
<p style="margin-top: 0px; margin-bottom: 0px;margin:0px; font-size:11px; line-height:normal; font-family:Menlo">
<span style="font-variant-ligatures:no-common-ligatures"> PostgreSQL config: /usr/pgsql-11/bin/pg_config</span></p>
<p style="margin-top: 0px; margin-bottom: 0px;margin:0px; font-size:11px; line-height:normal; font-family:Menlo">
<span style="font-variant-ligatures:no-common-ligatures"> PostgreSQL version: PostgreSQL 11.2</span></p>
<p style="margin-top: 0px; margin-bottom: 0px;margin:0px; font-size:11px; line-height:normal; font-family:Menlo">
<span style="font-variant-ligatures:no-common-ligatures"> PROJ4 version: 48</span></p>
<p style="margin-top: 0px; margin-bottom: 0px;margin:0px; font-size:11px; line-height:normal; font-family:Menlo">
<span style="font-variant-ligatures:no-common-ligatures"> Libxml2 config: /usr/bin/xml2-config</span></p>
<p style="margin-top: 0px; margin-bottom: 0px;margin:0px; font-size:11px; line-height:normal; font-family:Menlo">
<span style="font-variant-ligatures:no-common-ligatures"> Libxml2 version: 2.9.1</span></p>
<p style="margin-top: 0px; margin-bottom: 0px;margin:0px; font-size:11px; line-height:normal; font-family:Menlo">
<span style="font-variant-ligatures:no-common-ligatures"> JSON-C support: yes</span></p>
<p style="margin-top: 0px; margin-bottom: 0px;margin:0px; font-size:11px; line-height:normal; font-family:Menlo">
<span style="font-variant-ligatures:no-common-ligatures"> protobuf-c support: no</span></p>
<p style="margin-top: 0px; margin-bottom: 0px;margin:0px; font-size:11px; line-height:normal; font-family:Menlo">
<span style="font-variant-ligatures:no-common-ligatures"> PCRE support: no</span></p>
<p style="margin-top: 0px; margin-bottom: 0px;margin:0px; font-size:11px; line-height:normal; font-family:Menlo">
<span style="font-variant-ligatures:no-common-ligatures"> Perl: /usr/bin/perl</span></p>
<p style="margin-top: 0px; margin-bottom: 0px;margin:0px; font-size:11px; line-height:normal; font-family:Menlo; min-height:13px">
<span style="font-variant-ligatures:no-common-ligatures"></span><br>
</p>
<p style="margin-top: 0px; margin-bottom: 0px;margin:0px; font-size:11px; line-height:normal; font-family:Menlo">
<span style="font-variant-ligatures:no-common-ligatures"> --------------- Extensions --------------- </span></p>
<p style="margin-top: 0px; margin-bottom: 0px;margin:0px; font-size:11px; line-height:normal; font-family:Menlo">
<span style="font-variant-ligatures:no-common-ligatures"> PostGIS Raster: enabled</span></p>
<p style="margin-top: 0px; margin-bottom: 0px;margin:0px; font-size:11px; line-height:normal; font-family:Menlo">
<span style="font-variant-ligatures:no-common-ligatures"> PostGIS Topology: enabled</span></p>
<p style="margin-top: 0px; margin-bottom: 0px;margin:0px; font-size:11px; line-height:normal; font-family:Menlo">
<span style="font-variant-ligatures:no-common-ligatures"> SFCGAL support: enabled</span></p>
<p style="margin-top: 0px; margin-bottom: 0px;margin:0px; font-size:11px; line-height:normal; font-family:Menlo">
<span style="font-variant-ligatures:no-common-ligatures"> Address Standardizer support: disabled</span></p>
<p style="margin-top: 0px; margin-bottom: 0px;margin:0px; font-size:11px; line-height:normal; font-family:Menlo; min-height:13px">
<span style="font-variant-ligatures:no-common-ligatures"></span><br>
</p>
<p style="margin-top: 0px; margin-bottom: 0px;margin:0px; font-size:11px; line-height:normal; font-family:Menlo">
<span style="font-variant-ligatures:no-common-ligatures"> -------- Documentation Generation -------- </span></p>
<p style="margin-top: 0px; margin-bottom: 0px;margin:0px; font-size:11px; line-height:normal; font-family:Menlo">
<span style="font-variant-ligatures:no-common-ligatures"> xsltproc: /usr/bin/xsltproc</span></p>
<p style="margin-top: 0px; margin-bottom: 0px;margin:0px; font-size:11px; line-height:normal; font-family:Menlo">
<span style="font-variant-ligatures:no-common-ligatures"> xsl style sheets: </span></p>
<p style="margin-top: 0px; margin-bottom: 0px;margin:0px; font-size:11px; line-height:normal; font-family:Menlo">
<span style="font-variant-ligatures:no-common-ligatures"> dblatex: </span></p>
<p style="margin-top: 0px; margin-bottom: 0px;margin:0px; font-size:11px; line-height:normal; font-family:Menlo">
<span style="font-variant-ligatures:no-common-ligatures"> convert: </span></p>
<p style="margin-top: 0px; margin-bottom: 0px;margin:0px; font-size:11px; line-height:normal; font-family:Menlo">
<span style="font-variant-ligatures:no-common-ligatures"> mathml2.dtd: http://www.w3.org/Math/DTD/mathml2/mathml2.dtd</span></p>
<div><span style="font-variant-ligatures:no-common-ligatures"><br>
</span></div>
To get work postgres I had to add this file </div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt"><br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt">
<p style="margin-top: 0px; margin-bottom: 0px;margin:0px; font-size:11px; line-height:normal; font-family:Menlo">
<span style="font-variant-ligatures:no-common-ligatures">cat /etc/ld.so.conf.d/geos37-pgdg-libs.conf</span></p>
<p style="margin-top: 0px; margin-bottom: 0px;margin:0px; font-size:11px; line-height:normal; font-family:Menlo">
<span style="font-variant-ligatures:no-common-ligatures">/usr/local/lib/</span></p>
<p style="margin-top: 0px; margin-bottom: 0px;margin:0px; font-size:11px; line-height:normal; font-family:Menlo">
<span style="font-variant-ligatures:no-common-ligatures"><br>
</span></p>
<p style="margin-top: 0px; margin-bottom: 0px;margin:0px; font-size:11px; line-height:normal; font-family:Menlo">
<span style="font-variant-ligatures:no-common-ligatures">And in /usr/local/lib I have these files</span></p>
<p style="margin-top: 0px; margin-bottom: 0px;margin:0px; font-size:11px; line-height:normal; font-family:Menlo">
<span style="font-variant-ligatures:no-common-ligatures"><br>
</span></p>
<p style="margin-top: 0px; margin-bottom: 0px;margin:0px; font-size:11px; line-height:normal; font-family:Menlo">
<span style="font-variant-ligatures:no-common-ligatures">[root@vroomtest geos]# ls /usr/local/lib</span></p>
<p style="margin-top: 0px; margin-bottom: 0px;margin:0px; font-size:11px; line-height:normal; font-family:Menlo; color:rgb(51,196,38)">
<span style="color:rgb(76,122,255); font-variant-ligatures:no-common-ligatures">gdalplugins</span><span style="color:rgb(0,0,0); font-variant-ligatures:no-common-ligatures"> </span><span style="font-variant-ligatures:no-common-ligatures">libgdal.la</span><span style="color:rgb(0,0,0); font-variant-ligatures:no-common-ligatures"> </span><span style="color:rgb(30,255,255); font-variant-ligatures:no-common-ligatures">libgdal.so.1</span><span style="color:rgb(0,0,0); font-variant-ligatures:no-common-ligatures">
</span><span style="font-variant-ligatures:no-common-ligatures">libgeos-3.7.2.so</span><span style="color:rgb(0,0,0); font-variant-ligatures:no-common-ligatures"> libgeos_c.a </span><span style="color:rgb(30,255,255); font-variant-ligatures:no-common-ligatures">libgeos_c.so</span><span style="color:rgb(0,0,0); font-variant-ligatures:no-common-ligatures">
</span><span style="font-variant-ligatures:no-common-ligatures">libgeos_c.so.1.11.2</span><span style="color:rgb(0,0,0); font-variant-ligatures:no-common-ligatures"> </span><span style="color:rgb(30,255,255); font-variant-ligatures:no-common-ligatures">libgeos.so</span><span style="color:rgb(0,0,0); font-variant-ligatures:no-common-ligatures">
</span><span style="font-variant-ligatures:no-common-ligatures">liblwgeom-2.5.so.0.0.0</span><span style="color:rgb(0,0,0); font-variant-ligatures:no-common-ligatures"> </span><span style="font-variant-ligatures:no-common-ligatures">liblwgeom.la</span><span style="color:rgb(0,0,0); font-variant-ligatures:no-common-ligatures"> </span><span style="color:rgb(76,122,255); font-variant-ligatures:no-common-ligatures">pkgconfig</span></p>
<p style="margin-top: 0px; margin-bottom: 0px;margin:0px; font-size:11px; line-height:normal; font-family:Menlo">
<span style="font-variant-ligatures:no-common-ligatures">libgdal.a </span><span style="color:rgb(30,255,255); font-variant-ligatures:no-common-ligatures">libgdal.so</span><span style="font-variant-ligatures:no-common-ligatures"> </span><span style="color:rgb(51,196,38); font-variant-ligatures:no-common-ligatures">libgdal.so.1.18.5</span><span style="font-variant-ligatures:no-common-ligatures">
libgeos.a </span><span style="color:rgb(51,196,38); font-variant-ligatures:no-common-ligatures">libgeos_c.la</span><span style="font-variant-ligatures:no-common-ligatures"> </span><span style="color:rgb(30,255,255); font-variant-ligatures:no-common-ligatures">libgeos_c.so.1</span><span style="font-variant-ligatures:no-common-ligatures"> </span><span style="color:rgb(51,196,38); font-variant-ligatures:no-common-ligatures">libgeos.la</span><span style="font-variant-ligatures:no-common-ligatures">
</span><span style="color:rgb(30,255,255); font-variant-ligatures:no-common-ligatures">liblwgeom-2.5.so.0</span><span style="font-variant-ligatures:no-common-ligatures"> liblwgeom.a </span><span style="color:rgb(30,255,255); font-variant-ligatures:no-common-ligatures">liblwgeom.so</span></p>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt"><br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt">Then I started postgres and created a new database and adde the postgis extension and added the testdata.</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt"><br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt">Thanks .</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt"><br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt">Lars</div>
<br>
</div>
<div>
<div id="appendonsend"></div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" color="#000000" style="font-size:11pt"><b>From:</b> postgis-users <postgis-users-bounces@lists.osgeo.org> on behalf of Martin Davis <mtnclimb@gmail.com><br>
<b>Sent:</b> Friday, April 12, 2019 11:36 PM<br>
<b>To:</b> PostGIS Users Discussion<br>
<b>Subject:</b> Re: [postgis-users] diffrent execution plan on Postgres 9.5 and Postgres 11 for ST_union and performance problem Postgres 11</font>
<div> </div>
</div>
<div>
<div dir="ltr">
<div>I've figured out a fix for the performance reqression and it's now in GEOS master. My testing using the sample data provided above indicates it's at least 10x faster, so essentially eliminating the performance regression in this case (and it should provide
that for most situations) </div>
<div><br>
</div>
<div>If anyone can test further to confirm it is indeed faster and most importantly correct that would be great.</div>
<br>
<div class="x_gmail_quote">
<div dir="ltr" class="x_gmail_attr">On Thu, Apr 11, 2019 at 1:03 PM Martin Davis <<a href="mailto:mtnclimb@gmail.com">mtnclimb@gmail.com</a>> wrote:<br>
</div>
<blockquote class="x_gmail_quote" style="margin:0px 0px 0px 0.8ex; border-left:1px solid rgb(204,204,204); padding-left:1ex">
<div dir="ltr">
<div>Well, we have figured out what the problem is - it's a known regression in the GEOS UnaryUnion code, reported in this ticket [1]</div>
<div><br>
</div>
<div>Unfortunately there's no fix for this yet, but we'll try and escalate this.</div>
<div><br>
</div>
<div>[1] <a href="https://trac.osgeo.org/geos/ticket/867" target="_blank">https://trac.osgeo.org/geos/ticket/867</a></div>
<br>
<div class="x_gmail_quote">
<div dir="ltr" class="x_gmail_attr"><br>
</div>
<blockquote class="x_gmail_quote" style="margin:0px 0px 0px 0.8ex; border-left:1px solid rgb(204,204,204); padding-left:1ex">
</blockquote>
</div>
</div>
</blockquote>
</div>
</div>
</div>
</div>
</body>
</html>