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

Frederik Ramm frederik at remote.org
Thu May 6 22:12:28 BST 2010


    I had posted about performance problems with Postgres 8.4 in 
September last year already. With Ubuntu Lucid just released, which 
comes with 8.4 by default, I played around some more. Unfortunately I am 
still a little bit away from having systematic, comparable results, but 
I have the impression that importing updates with osm2pgsql is somehow 
buggy (performance-wise) in 8.4.

I'm running this on a machine with SSD. With 8.3, the process was 
disk-bound despite SSD, which is what I would expect, after all there's 
not much to compute.

With 8.4, a (large, ~ 1 day) test diff takes about four times as long to 
load. This is unacceptable and I will probably have go back to 8.3 
because of that until I can find out exactly what the problem is.

When searching for possible reasons on the web, I found this message 
about Postgres 9.0 and irregularities with intarray index usage:


It could have *something* to do with what I am seeing, however I could 
not reproduce intarray operations being slower from within a function 
than from the command line.

I'll investigate this further and report back with anything I find; for 
the time being just be warned that there are isolated indications of 
Postgres 8.4 being less suitable for OSM than 8.3. (I am largely 
ignorant of any changes between 8.3 and 8.4, and simply set my config 
options to the same I had been using with 8.3; it is possible that 8.4 
requires something to be configured differently to work.)

I'd also be interested to hear from anyone who, despite this message, 
plays with 8.4 (or even 9.0 alpha) and has something to say.


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

More information about the dev mailing list