[OSM-dev] osm2pgsql slow slim import

Martijn van O kleptog at gmail.com
Fri Dec 2 22:12:00 GMT 2011


2011/12/1 "Petr Morávek [Xificurk]" <xificurk at gmail.com>:
> Actually, I have just found out that the most important is
>
> synchronous_commit = off
>

If synchronous_commit is helping so much that means that the code is
doing far too many transactions. Obviously there needs to be some
BEGIN/COMMIT added somewhere to reduce the number of transactions.

Have a nice day,
-- 
Martijn van Oosterhout <kleptog at gmail.com> http://svana.org/kleptog/



More information about the dev mailing list