[OSM-dev] osm2pgsql slow slim import

Kai Krueger kakrueger at gmail.com
Fri Dec 2 06:23:42 GMT 2011


"Petr Morávek [Xificurk]" wrote
> 
> 1) fsync = off, synchronous_commit = off
> 1990 s = 33 min
> 
> 2) fsync = on, synchronous_commit = off
> 3075 s = 51 min
> Interestingly, most of the time difference comes from the initial import
> of relations.
> 
Yes, I noticed that as well, that the initial relations processing seems
much slower with fsync = on. As that part should be fully in a single
transaction, fsync'ing on transaction commit shouldn't really affect this.
So I don't yet know why this is happening. But perhaps we can figure that
one out as well...

Kai




--
View this message in context: http://gis.638310.n2.nabble.com/osm2pgsql-slow-slim-import-tp7044819p7053702.html
Sent from the Developer Discussion mailing list archive at Nabble.com.



More information about the dev mailing list