2009/4/16 Frederik Ramm <frede...@remote.org>: > Hi, > > Dave Stubbs wrote: >> >> Somewhere between 4-5GB is required at the moment -- it increases all >> the time though :-) > > Oh, then I have seriously overestimated the memory usage... I was unable to > do Europe on a 2 GB machine so I figured the planet must require something > like 20... >
That's probably the way osm2pgsql uses RAM in non-slim mode. It stores nodes by maintaining a fixed array of pointers to dynamically allocated arrays of about 2^14 nodes with sequential IDs. So if you have ids sparsely distributed then it allocates a lot of memory for just a few nodes and there's a lot of wasted space. Dave _______________________________________________ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk