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