[OSM-dev] osm2pgsql slow on update import

Markus Wagner markus at mwagner.info
Thu Apr 14 15:29:19 BST 2011


> Seconded.  I have my database on a RAID1 pair of 5.4K RPM drives (which
> gives me a speed up in reads and data redundancy, but seems about the same
> as a single disk in terms of writes) and am using PostgreSQL 9.0.  Before
> the fastupdate patch, one minute of diffs took between 2 and 5 minutes to
> apply.  Now my system can keep up with the diffs easily despite constant
> rendering on both of the CPU's cores.

Thanks, Phil, for your configuration file.

After vacuuming and fiddling with those values I am much closer to  
realtime. Currently at approx ~120% of realtime. So I think, there is  
hope, once I get faster disks.

Markus






More information about the dev mailing list