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
> 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.
More information about the dev