Hacker News new | ask | show | jobs
by sheraz 4849 days ago
Somewhat relevant, but on a much smaller scale I suppose:

I had to geocode 100million addresses and used PostGIS to get it done. It was painfully slow on disk, so I rented some big-ram servers, created ramdisks, configured postgres to run from those ramdisks, and it was off to the races.

What would have taken days of processing was taken down to several hours. The speed improvement was amazing. Even SSD couldn't touch it.