[OSM-talk] Slim mode in osm2pgsql and out of memory error

Jukka Rahkonen jukka.rahkonen at latuviitta.fi
Thu Jun 9 08:49:00 BST 2011


Martijn van Oosterhout <kleptog <at> gmail.com> writes:

> 
> On 9 June 2011 08:38, Saphy Mo <saphyfar <at> yahoo.com> wrote:
> > The file is the same Europe.osm.bz2 directly downloaded from geofabrik. I
> > will decomprese it and try to see the order of Nodes, Ways and relation.
> > But the error happens while pending_ways query.
> 
> It occurs to me you can see this during import, by seeing which
> counters go up first.

The osm2pgsql wiki http://wiki.openstreetmap.org/wiki/Osm2pgsql#Optimization
says "it is smart to increase the value of checkpoint_segments". I have a
feeling that it is compulsory, at least I was not able to import the Finnish
excerpt at all with the PostgreSQL 9.0 default value. But perhaps you have
increased it already.

-Jukka Rahkonen-




More information about the talk mailing list