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

[Martijn van Oosterhout]

On 8 June 2011 17:11, Martijn van Oosterhout <kleptog at gmail.com> wrote:
> Actually, it looks like it's breaking on the pending_ways query. It's
> possible there's a lot of those, perhaps it's just running out of
> memory there. The code was designed that pending would only be for
> changes, and I wouldn't have expected that code to be used for an
> initial import. but I haven't look at the code recently so maybe that
> changed?
>
> If it is the intention that this code is used for initial imports it
> really needs to be changed to use cursors.

Actually, it occurred to me that the system is optimised to the case
where the file contains nodes, then ways, then relations. What you're
seeing could be caused by the file having the ways first, then the
nodes. Can you examine the file to see how it looks?

Have a nice day,
-- 
Martijn van Oosterhout <kleptog at gmail.com> http://svana.org/kleptog/