[OSM-dev] osm2pgsql slow on update import
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.
More information about the dev