[OSM-dev] applying hourly OSM diffs with osmosis gradually messes up database

Stephan Knauss osm at stephans-server.de
Mon Aug 1 11:59:32 BST 2011


Peter Körner writes: 

> Some people try to reduce the size by running a DELETE once a week just 
> before the VACUUM.

problem is that ways and relations don't have a geometry. So osm2pgsql 
would need to do asdditional lookups when processing a bounding box. 

I thought about fixing it but found that a regular cleanup is a lot cheaper. 

See here:
http://wiki.openstreetmap.org/wiki/User:Stephankn/knowledgebase#Cleanup_of_w
ays_outside_the_bounding_box 

Stephan



More information about the dev mailing list