[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:06:13 GMT 2011

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

More information about the dev mailing list