Hi, I've imported the planet file on my system about 8 months ago and would like to update my database now.

My question: Should I update my database with osmosis & osm2pgsql with --append or rather do a new full import with the latest planet file? Which way is better/faster/less complicated?

The first planet import took about 25 hours (42GB planet-file). Latest planet-file now is 45GB.

Regards

asked 11 Jun, 17:52

Maik28's gravatar image

Maik28
113
accept rate: 0%


Trying to update your 8-month-old data is going to take vastly longer than a full re-import. As a rule of thumb, as soon as you're more than 2 weeks out of date, a new import is usually faster. Only reason to try an update would be if you cannot afford the database to be down for 1.5 days - but running an 8-month update will likely make your database veeeery slow for 15 days ;)

permanent link

answered 12 Jun, 12:59

Frederik%20Ramm's gravatar image

Frederik Ramm ♦
70.0k806341097
accept rate: 24%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×163
×49

question asked: 11 Jun, 17:52

question was seen: 186 times

last updated: 12 Jun, 12:59

powered by OSQA