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

Ian Dees ian.dees at gmail.com
Mon Feb 14 15:14:42 GMT 2011


It took me roughly 2 days to catch up with a week's worth of changes.

On Mon, Feb 14, 2011 at 9:11 AM, IgnacioZ <zignacio at gmail.com> wrote:

> 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/a0e6fd57/attachment.html>


More information about the dev mailing list