[postgis-users] diffrent execution plan on Postgres 9.5 and Postgres 11 for ST_union and performance problem Postgres 11

Martin Davis mtnclimb at gmail.com
Fri Apr 12 14:36:35 PDT 2019

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)

If anyone can test further to confirm it is indeed faster and most
importantly correct that would be great.

On Thu, Apr 11, 2019 at 1:03 PM Martin Davis <mtnclimb at gmail.com> wrote:

> Well, we have figured out what the problem is - it's a known regression in
> the GEOS UnaryUnion code, reported in this ticket [1]
> Unfortunately there's no fix for this yet, but we'll try and escalate this.
> [1] https://trac.osgeo.org/geos/ticket/867
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20190412/0e1647a1/attachment.html>

More information about the postgis-users mailing list