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 [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
