[OSM-dev] load-osm.sh

Ilya Zverev ilya at zverev.info
Mon Oct 13 07:35:02 UTC 2014


Paul Norman wrote:
> On 10/12/2014 2:49 PM, Ilya Zverev wrote:
>> Hi! Yesterday I had a simple task: there is a rendering server, which
>> is not to be minutely updated. So its PostgreSQL database doesn't need
>> temporary "slim" tables. But I cannot import an extract without
>> creating those, so basically I can import 3 times less data than
>> possible.
> It's worth noting that the --drop mode in osm2pgsql will delete the slim
> tables when done, and also not create the indexes on those tables. As
> those indexes are large, this is a substantial space savings in itself.
> --drop also will create more compact indexes for the rendering tables.

Oh. I forgot to check osm2pgsql options and missed --drop. Now it's been 
added as an extra mode "loadc". It is ~7% faster than "load"+"clean", 
and produces an sql dump of nearly the same size. Thanks.

IZ



More information about the dev mailing list