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

[Paul Norman]

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.