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

Reply via email to