[OSM-dev] osm2pgsql not appending changeset?

Ákos Maróy akos at maroy.hu
Wed Dec 7 07:14:15 GMT 2011

On 07/12/11 07:36, Kai Krueger wrote:
> If you are intending to only update the diffs every week or less (as opposed
> to minutely, hourly or daily), you might want to consider simply doing a
> fresh import every week. If you have sufficient ram, then you can use the
> non-slim mode, otherwise you could consider the slim mode with the --drop
> option. Both are considerably faster than the normal slim mode import.

this is what I want to avoid, as a full import took me 5 days,
maintaining a considerable IO load (and thus a lot of waiting processes)
during this period.

> Applying diffs with osm2pgsql is orders of magnitude slower per element than
> the initial import. Which makes a full import faster even for moderately
> short periods of diff application. Where the change-over lies exactly,
> probably depends somewhat on the hardware, but applying a weeks diffs will
> probably take a few days.

oh, I see. thanks...

More information about the dev mailing list