I currently use Geohash to index some points and retrieve information faster by providing a geohash prefix for a given point for a given distance.. For example if I get a given point at '1600 ...
I wonder if there could be a performance gain to re organize the rows in a table by Geohash and then CLUSTER this table on the Geohash index of the geometries. CREATE TEMPORARY TABLE tmptbl AS SELECT ...
I'm looking to optimize point proximity geo searches time. My input is lat,lng point and I'm searching on a precomputed set of locations to n nearest points. I don't care how much time/space the ...