[OSM-dev] osmosis too slow to write a changes file to a postgis DB?
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?
> 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
>>> dev mailing list
>>> dev at openstreetmap.org
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the dev