[OSM-dev] Patch to osm2pgsql for faster updates

Peter Körner osm-lists at mazdermind.de
Sun Jan 23 18:05:23 GMT 2011


First import ist fast, index creation after it is normal. When the 
minutely updates start, they're fast at beginning but tend to get slower 
and slower until they get slower than realtime (eg. 5 minutes of changes 
take 10 minutes to import).

In a normal setup, the diffs take around 1/2 the realtime (eg. 5 minutes 
of changes are imported in ~2,5 minutes), depending on the disks used.

Peter

Philipp Borgers schrieb:
>> Do we actually know that 9.0 is ok though? I was basing my comments on a
>> single report of some preliminary tests at SOTM last year.
>
> Can someone explain the problem itself? We will set up our xapi database
> tomorrow and we would like to use 9.0. We can do some testing on 8.* and
> 9.* if you explain the problem and how to reproduce it.
>
> best regards
>
> philipp
>
>
> _______________________________________________
> dev mailing list
> dev at openstreetmap.org
> http://lists.openstreetmap.org/listinfo/dev



More information about the dev mailing list