I was using PostGIS for vehicle tracking at my last job. PostGIS made it really simple by allowing me to boil everything down to simple geometry. The performance is amazing. The CTO told me I was doing it wrong and I should be using some homebrew solution in the middle tier that would do a comparison of 2,000+ points each GPS update. Why reinvent the wheel? Let the experts handle the geospatial functions.