[OSM-dev] osm2pgsql: diffs involving relations now work also

[Jon Burgess]

On Fri, 2008-07-11 at 15:59 +0200, Martijn van Oosterhout wrote:
> I've just committed the necessary changes to make diffs that change
> ways properly reconstruct the relations that refer to it. That just
> leaves the parking node problem which hasn't got a nice solution yet.
> I don't expect it to be a problem in the short term though.
> 
> What this code needs now is lots of testing. To run this on a full
> planet dump you will need on the order of 40GB of disk space, possibly
> more (if anyone gets it to run to completion, could you post the disk
> used, thanks). Note it will probably take quite a while unless you
> have more than 1GB of memory and configure the --cache parameter to
> use it. 10 hours is not unusual.

I have imported last weeks planet dump into a new set of tables on the
main tile server. The increase in disc usage was 41GB and took about 2
hours longer than the non-slim import:

time ./osm2pgsql --slim -p slim -C 2000 /home/www/tile/direct/planet/planet-080709.osm.gz
...
9156.42user 96.11system 5:28:28elapsed 46%CPU (0avgtext+0avgdata 0maxresident)k


> That said, testing can be done on a smaller scale. Pick two extract
> from the same areas and use osmosis to make a diff. Load the first
> file, then load the diff and compare it to the second file (somehow).

I'm starting to apply the daily diffs now. I'll let you know how I get
on. 

	Jon