[postgis-users] Help optimizing query

[Luca Bertoncello]

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
(lucabert at lucabert.de)