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
_______________________________________________
dev mailing list
[email protected]
https://lists.openstreetmap.org/listinfo/dev
