I imported tucson.osm.pbf, a 3.4MB OSM extract.
| Where is PostgreSQL | Machine Specs | Import time |
|---|---|---|
| Local | 4 CPU, 16GB RAM Macbook Pro | 18 seconds |
| Local | i2.4xlarge EC2 | 76 seconds |
| Remote | m1.medium EC2 > db.m1.large 500GB : 2000 IOPS | 112 seconds |
| Remote | i2.4xlarge EC2 > db.m2.4xlarge 1000GB : 10000 IOPS | 82 seconds |
I also imported paris.osm.pbf, a 169MB OSM extract.
| Where is PostgreSQL | Machine Specs | Import time |
|---|---|---|
| Local | 4 CPU, 16GB RAM Macbook Pro | 1762 seconds |
| Remote | i2.4xlarge EC2 > db.m2.4xlarge 1000GB : 10000 IOPS | 1442 seconds |
Remember: --flat-nodes is a BAD idea for small imports, but starts to pay off once things get a little larger.