Skip to content

Instantly share code, notes, and snippets.

@rclark rclark/rds-troubles.md
Last active Jan 4, 2016

Embed
What would you like to do?

Import times with osm2pgsql

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.