News Score: Score the News, Sort the News, Rewrite the Headlines

Loading the World! OpenStreetMap Import In Under 4 Hours | Crunchy Data Blog

The OpenStreetMap (OSM) database builds almost 750GB of location data from a single file download. OSM notoriously takes a full day to run. A fresh open street map load involves both a massive write process and large index builds. It is a great performance stress-test bulk load for any Postgres system. I use it to stress the latest PostgreSQL versions and state-of-the-art hardware. The stress test validates new tuning tricks and identifies performance regressions.Two years ago, I presented (vide...

Read more at crunchydata.com

© News Score  score the news, sort the news, rewrite the headlines