[postgis-users] Very long query time

[Tumasgiu Rossini]

I do not really understand.
Is it a query which used to be faster ?

A little remark on your where clause :
it is unnecesseraly complicated and could be shortened to :
    WHERE st_intersects(zi.geom, tile.geom)

True and false value doesn't need to be surronded by quote,
here you are implicitly casting the string value 'true' to its boolean
representation


Le jeu. 6 déc. 2018 à 16:53, Manchon Pierre <pierre.manchon at irstea.fr> a
écrit :

> Hello there,
>
> I'm new on the list and for a premiere I would like to know if some of you
> have a very long runtime for some of their queries (even with a LIMIT 5),
> whereas those queries were working well before (nothing changed from
> that).  I'm using Postgre10, pgAdmin4 and postgis 2.4.4 on windows …
>
>
>
> The infinite query I’m trying to execute: (only ~500 rows are stored on
> each of the two tables)
>
>
>
> SELECT code_tile, code_zi FROM data.tile, data.zi
>
> WHERE ST_Intersects(zi.geom, tile.geom) = 'true'
>
> GROUP BY code_zi, code_tile, zi.geom, tile.geom
>
> LIMIT 5
>
>
>
> Thank you for your time
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20181206/1ea6bdc4/attachment.html>