I have a table called
Stores with 10k rows which has a column
CREATE INDEX "Stores_spatial_gix" ON "Stores" USING gist (location);
Upon KNN query
explain analyze select * from "Stores" order by ST_distance_sphere(location,st_point(-82.373978, 29.633657)) limit 3
I get about 800ms each time. What am I doing wrong that it takes so long time?