Postgres - Adding geo index and query within distance
ALTER TABLE some_table ADD COLUMN geom geometry(Point,4326);
UPDATE my_table SET geom = ST_SetSRID(ST_MakePoint(longitude, latitude), 4326);
CREATE INDEX my_table_geom_idx ON my_table USING gist(geom);
SELECT latitude, longitude,geom FROM my_table WHERE ST_DWithin(geom, ST_MakePoint(1.292846,52.63066)::geography, 1609 * 5);