|
I've started a full osm planet import 6 days ago with: It is now at: So nodes have been processed, ways almost, relations not yet. Is it possible to estimate how more days it will take to finalize? 2nd point: I followed the instruction for optimizing PostgreSQL (set "osm2pgsql relies much on its node cache during import. If the nodes do not fit into the cache in slim mode it needs to do database lookups which slow down the process. (Without slim mode, it fails if the nodes do not fit in the cache). Use enough cache so all nodes are cached. -C 22000 seems to do the job, even if that means you have to configure more swap space." Does it make sense to kill the osm2pqsql process and restart with |
|
You're likely to get a performance of under 5 relations per second on this machine, which would mean at least a week for relation processing, and after that you still need to go through index creation. My guess is that you're looking for at least two more weeks here. You can speed up the job with more cache and the --flatnodes option but probably not by 30%. The fastest way to get a planet file imported is to order a large SSD disk and install it to your server. If you order it now, receive it tomorrow, install it a day later, and then restart the import, you can be done within a week. |
