[postgis-users] ST_Intersection very slow

[Rémi Cura]

I don't think it will be fastest to compute the subdivide, but it would be
way fastest to use it for processing afterward !
Cheers,
Rémi-C

2015-03-05 13:00 GMT+01:00 Mark Wynter <mark at dimensionaledge.com>:

> Yes Remi - you have understood correctly how the quadgrid function works -
> I will have a play with the quadgrid tomorrow, then let's share notes.
>
> > If I understand you correctly, you would subdivide like you do
> currently, but the depth of subdivision would be a function of number of
> points remaining in the square?
> > It would be a great feature, at a reasonable cost (you would need to
> change only a few lines in your code)
>
> I think this is the step where we are either going to get performance lift
> or not
>
> >
> > I'm going to test it tomorrow, I would expect to break the 10 minutes
> marks (1 core), but I'm not certain
>
> Cool!
>
> > In fact we could combine our approaches, I'll start thinking about that.
> >
> > Cheers,
> > Rémi-C
> >
> >
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20150305/eb139d2c/attachment.html>