I have a table called Stores with 10k rows which has a column location geometry(Point,4326).
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 3I get about 800ms each time. What am I doing wrong that it takes so long time?
أكثر...
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 3I get about 800ms each time. What am I doing wrong that it takes so long time?
أكثر...