[OSM-dev] osmosis too slow to write a changes file to a postgis DB?

IgnacioZ zignacio at gmail.com
Mon Feb 14 15:11:26 GMT 2011


It's an 11 days changes file (from the previous planet file up to today).

According to this, it could be faster to recreate the whole database than to
continue with this update.

Any ideas if it can be improved?

Thanks

On Mon, Feb 14, 2011 at 12:06 PM, Ian Dees <ian.dees at gmail.com> wrote:

> What change file are you using? What time frame does it cover?
>
> 7200 RPM disks are fairly slow for this sort of intensive database work,
> but on similar disks (Caviar Black 7200rpm 1TB drives) it would take
> anywhere from 5-70 seconds to apply one minute's worth of diffs.
>
> On Mon, Feb 14, 2011 at 9:01 AM, IgnacioZ <zignacio at gmail.com> wrote:
>
>> Hi, I am currently running osmosis to update a postgis osm simple schema
>> (with linestring and bbox in ways) using a change file. I am using pv to see
>> the throughput and it shows it is being parsed at 4Kb/s.
>>
>> I'm running on an i7 920 server with 12GB Ram and a 7200RPM disk.
>>
>> This is a 5GB file so it will take too long to parse... Is that speed what
>> is expected with my system configuration? Is there any way to make it
>> faster?
>>
>> Thanks!
>> Ignacio.
>>
>> _______________________________________________
>> dev mailing list
>> dev at openstreetmap.org
>> http://lists.openstreetmap.org/listinfo/dev
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20110214/60d17aef/attachment.html>


More information about the dev mailing list