Re: [OSM-dev] Postgres 8.4 performance trouble in osm2pgsql setup

2010-05-13 Thread Martijn van Oosterhout
It's probably worth reporting if you can find a test case. However, I'd first suggest: - Ruling out caching effects. It's not just because the 8.3 database has been running for a while already and the 8.4 has just started up? - Are the two servers configured the same. Compare the config files,

Re: [OSM-dev] Postgres 8.4 performance trouble in osm2pgsql setup

2010-05-11 Thread Pieren
On Sat, May 8, 2010 at 1:11 AM, Frederik Ramm frede...@remote.org wrote: The intial import went all right on 8.3 and 8.4; my 4 times slower was about adding a daily diff to the data base. Just for information, I also compared the performance on my Ubuntu 10.04 Lucid, amd64 distrib (ext4, hdd

Re: [OSM-dev] Postgres 8.4 performance trouble in osm2pgsql setup

2010-05-07 Thread Steve Singer
On Sat, 8 May 2010, Frederik Ramm wrote: The intial import went all right on 8.3 and 8.4; my 4 times slower was about adding a daily diff to the data base. The node changes were reasonably fast, and then it took ages to process the way changes. I think I'll instrument osm2pgsql to produce