[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