Yes had the same solution ~15 years ago when location based search got popular. Searching for anything within some distance to a defined location with perfect e

Yes had the same solution ~15 years ago when location based search got popular. Searching for anything within some distance to a defined location with perfect earth projection and a circle radius „did not scale“. Ignoring the earth‘s projection and pretending a flat earth with a rectangle search was much much faster. In the end we used this simplified calculation with added „regions“. So the world was split into 15km*15km squares, so any square being more than x apart could never be in the result set. This could maybe be used with modern postgresql partitioning and partition elimination in a clever way. And without partitioning maybe clever z-ordering the entries physically in the database (clustering) could reduce a lot of random i/o.