[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
Thu Apr 11 11:07:13 PDT 2019

On Thu, Apr 11, 2019 at 3:27 AM Lars Aksel Opsahl <Lars.Opsahl at nibio.no>

> Can it be problem related ST_Union and aggregate ?

Can you test the performance of aggregate ST_Union on it's own by dropping
the GROUP BY and instead using a WHERE clause to union a small-ish subset
of the geometries?  (But large enough to give a measurable query time.)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20190411/dce9dde0/attachment.html>

More information about the postgis-users mailing list