Haversine vs PostGIS: A Small Experiment with 1 Million Locations

I was working on a location-based search for a service marketplace.The requirement was simple: Given a user's latitude and longitude, find nearby service providers and order them by distance. My fir