[postgis-users] Improvement suggestion

Nicolas Ribot nicolas.ribot at gmail.com
Mon Dec 3 11:50:40 PST 2018


Hi,

Did you cut your big polygons with st_subdivide before intersecting them ?
It usually speeds up queries by several orders of magnitude.

Nicolas

On Mon, 3 Dec 2018 at 18:41, Paul van der Linden <paul.doskabouter at gmail.com>
wrote:

> I indeed know that trick to eliminate an st_intersection, but that comes
> at the cost of a st_within.
> In the test-case I'm examing now, the st_intersects and st_within both
> take about 40 seconds and the st_intersection takes about a minute.
> So to eliminate one of the 40 seconds (and in this case even the
> intersection because st_within is true), a function returning the relation
> could speed up things
> _______________________________________________
> 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/20181203/f7157690/attachment.html>


More information about the postgis-users mailing list