[postgis-users] Performance external loop, WHERE IN (values), stored procedure or else to pass data to SQL query

Paul Norman penorman at mac.com
Thu Jun 16 12:41:10 PDT 2016

On 6/14/2016 3:53 AM, Michal Seidl wrote:
> With other operators ST_Distance,ST_Equal, = the spatial index is not 
> used (?) and query take about 500ms. 500 points x 500ms => 250s which 
> is quite a lot and I do not take into account time spent on python 
> side. That's the problem. 

Do everything in one query which does all of the points at once.

More information about the postgis-users mailing list