[postgis-users] ST_Intersection very slow
Mark Wynter
mark at dimensionaledge.com
Thu Mar 5 04:00:29 PST 2015
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
>
>
More information about the postgis-users
mailing list