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