[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