* Frederik Ramm <[email protected]> [2011-04-05 11:58 +0200]: > Make sure you've got at least osm2pgsql r25198 (31st Jan) as this will > turn the "fastupdate" feature off. The impact of this is most > pronounced on Postgres 8.4 but seems to be present on 9.0 also.
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. -- ...computer contrarian of the first order... / http://aperiodic.net/phil/ PGP: 026A27F2 print: D200 5BDB FC4B B24A 9248 9F7A 4322 2D22 026A 27F2 --- -- Einstein argued that there must be simplified explanations of nature, because God is not capricious or arbitrary. No such faith comforts the software engineer. -- Fred Brooks, Jr. ---- --- -- _______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/dev
