[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