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

Richard Weait richard at weait.com
Wed Jun 8 15:48:45 BST 2011


On Wed, Jun 8, 2011 at 10:44 AM, Saphy Mo <saphyfar at yahoo.com> wrote:
> Dear friend,
> I am trying to import whole Europe.os.bz2 in a Postgis database named
> EuropeLl as you see in the script below.
> CPU: Dual Coe 3 Ghy
> RAM: 3 GB
> HDD: 1 TB
> osm2pgsql.exe -d EuropeLL --latlong --slim -c -C 500 -H localhost -P 5432 -U
> osm -W -S default.style europe.osm.bz2
> ------------------------------------------------------------------------------------------------------------------
> It reads Nodes(495155k), Ways(57513k), relations(669k) properly.
> Exception Caught processings ways id=1479960
> Processing: Node(495155k),Ways(57513k), relations(718k)
> Node State: total (495155996),max(1281994925)
> Way state: total(57513025), max(158054)
> going over pending ways
> pending_ways faild : out of memory for query result
> (7)
> error occurred cleaning up
> --------------------------------------------------------------------------------------------------------------------
>
> Please let me know, what I shoud modify and change to get it working.
> Shoudl I use a PC with more than 8 or 16 GB


-C 500  # limits osm2pgsql to 500MB.  Default is 800MB iirc.  Try that, or more.



More information about the talk mailing list