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- _______________________________________________ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk