Marcin Cieslak schrieb:
Peter Körner osm-lists@mazdermind.de wrote:
Peter Körner schrieb:
Tim Alder schrieb:
Please have also my wish-list in mind for the time of re-import: shop, lit, cycleway, operator, surveillance, website, wikipedia
I just started the new import. I used this style definition: http://cassini.toolserver.org/~mazder/wikimedia.extended.style
The import was canceled after 6 hours when it started to generate the indexes. I'm doing an import with a new prefix (--prefix planet_osm_new) and afterwards rename the current tables to planet_osm_old and the new ones to planet_osm.
Did you run into constraints/internal consistency problem?
No I just forgot to rename the indices :) After 6 hours the import was already nearly done and osm2psql instructed postgres to create the indices and then it realised that they already existed and rolled back the changes.
The speedup (6h instead of 20h) came from the increased cache size (800MB -> 10GB)
This is the script I'm currently working on: http://cassini.toolserver.org/~mazder/planet-update
The diff-releated actions are not done right now and the urls of the world_boundaries are wrong, but the rest seemed to work..
Peter