[postgis-users] ST_Union(ST_Buffer(...)) hangs for large polygons on RHEL7/CentOS7 / PG 9.5

[Jason Greenlaw - NOAA Affiliate]

Hi Raúl,

I think you may be right.

The original server which experienced the issue is on GEOS 3.7.1:

POSTGIS="2.4.8 r17696" PGSQL="95" GEOS="3.7.1-CAPI-1.11.1 27a5e771"
PROJ="Rel. 4.9.3, 15 August 2016" GDAL="GDAL 2.3.2, released 2018/09/21"
LIBXML="2.9.1" LIBJSON="0.11" LIBPROTOBUF="1.0.2" RASTER


The CentOS 7 VM I tested is on GEOS 3.7.2:

POSTGIS="2.5.3 r17699" [EXTENSION] PGSQL="95" GEOS="3.7.2-CAPI-1.11.2
b55d2125" PROJ="Rel. 6.2.0, September 1st, 201
9" GDAL="GDAL 3.0.1, released 2019/06/28" LIBXML="2.9.1" LIBJSON="0.11"
LIBPROTOBUF="1.0.2" TOPOLOGY (topology procs
from "2.2.5 r15298" need upgrade) RASTER


And the crunchy images are also on GEOS 3.7.2

POSTGIS="2.5.3 r17699" [EXTENSION] PGSQL="95" GEOS="3.7.2-CAPI-1.11.2
b55d2125" PROJ="Rel. 6.2.0, September 1st, 2019" GDAL="GDAL 3.0.1, released
2019/06/28" LIBXML="2.9.1" LIBJSON="0.11" LIBPROTOBUF="1.0.2" RASTER


The mdillon/postgis images, which don't exhibit the issue, appear to be on
GEOS 3.5.1:

POSTGIS="2.5.2 r17328" [EXTENSION] PGSQL="95" GEOS="3.5.1-CAPI-1.9.1 r4246"
PROJ="Rel. 4.9.3, 15 August 2016" GDAL="GDAL 2.1.2, released 2016/10/24"
LIBXML="2.9.4" LIBJSON="0.12.1" LIBPROTOBUF="1.2.1" TOPOLOGY RASTER


Thanks for testing and pointing me to the GEOS bug - really appreciate the
help!

Jason



On Tue, Oct 8, 2019 at 12:34 PM <rmrodriguez at carto.com> wrote:

> Hi,
>
> This seems related to https://trac.osgeo.org/postgis/ticket/4075. What
> version of GEOS are you using in each server?
>
> I've tried with Postgis 3.0 and GEOS 3.8 and it hasn't finished after
> ~10 minutes.
>
> Regards
> --
> Raúl Marín Rodríguez
> carto.com
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20191008/c387b54d/attachment.html>