[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis-users] Performance external loop, WHERE IN (values), stored procedure or else to pass d
From:       Michal Seidl <michal.seidl () gmail ! com>
Date:       2016-06-23 11:16:54
Message-ID: 576BC526.1050007 () gmail ! com
[Download RAW message or body]

Hi,
thanks for advice. CTE looks like the solution for me. I did not measure 
any performance but it is obviously better than test each point in a loop.

M

On 06/13/2016 08:46 PM, Leknín Řepánek wrote:
> Python Array -> geometry(POINT, [SRID])[] -> unnest, you can use unnest
> in CTE
> something like
>
> WITH cte AS (
> 	SELECT unnest(array['POINT(1 1)'::geometry ......]) pnt
> )
> SELECT * FROM t JOIN cte ON ST_....
>
>
> Milions of points aren`t big data, if it is slow, maybe you should check
> your indexes.
>
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/postgis-users
[prev in list] [next in list] [prev in thread] [next in thread]