[OSM-dev] Postgres 8.4/PostGIS 1.4 performance

Martin Lesser ml-osm-dev at bettercom.de
Wed Sep 16 20:39:18 BST 2009


Frederik Ramm <frederik at remote.org> writes:

>     I did a full (osm2pgsql) planet import on a standard Ubuntu Jaunty 
> system and it took 1794 minutes. Then I upgraded to Postgres 8.4 
> (backported from Karmic) plus PostGIS 1.4 (home-built package), and 
> re-tried the import: 2028 minutes (that's 13% performance loss).
>
> Can anybody confirm this measurement, or even suggest what the reason 
> might be?

Another pointer: How many VACUUMs does osm2pgsql trigger during import
and filling the own tables?

I also registered some slowing down with my own application when it
comes to VACUUM. And I also read some mailings about this issue on the
PG-MLs. AFAIR osm2pgsql does not timestamp its steps so it is probably a
little difficult to hunt the real timeconsumer down.

HTH, Martin




More information about the dev mailing list