Am 21.12.2022 um 16:43 schrieb Regina Obe: Hi Regina,
> 1) Make sure you do have a gist index on latlng This was my error... I created an Index just doing: CREATE INDEX idx_elevation_latlng ON elevation (latlng); Now I recreated the index with: CREATE INDEX idx_elevation_latlng ON elevation USING gist (latlng); and the query is very fast... Regards Luca Bertoncello ([email protected]) _______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
