[OSM-dev] Patch to osm2pgsql for faster updates

Frederik Ramm frederik at remote.org
Sat Jan 29 09:56:15 GMT 2011


Hi,

Erik Burrows wrote:
> This is almost the exact same data set, same hardware, and same tile
> set. 37 minutes for PG 8.4, and 87 minutes for 9.0. I ran the test
> twice!

[...]

> I don't have an explanation. All I can think of to try to debug is to
> set "log statement duration=0", and use mapnik_tiles.py to trace each
> command, and compare the times. I'll do this over the next day or so.

Any news on this? Have you used the same PostGIS version with PG8.4 and 9.0?

Bye
Frederik

-- 
Frederik Ramm  ##  eMail frederik at remote.org  ##  N49°00'09" E008°23'33"



More information about the dev mailing list