[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