[Tile-serving] [openstreetmap/osm2pgsql] COPY_END for planet_osm_polygon failed: ERROR: out of memory (#846)

[Hartmut Holzgraefe]

It is the PostgreSQL process that is executing 

`COPY planet_osm_polygon (osm_id,"layer","way_area","z_order",tags,way) FROM STDIN`

The machine has 64GB, the postgres process grows up to ~60GB before failing.

The osm2pgsql cmdline is:`

`osm2pgsql --append --slim --flat-nodes=$FLAT_NODE_FILE --database=gis --merc --hstore-all --cache=5000 --style=$STYLE --tag-transform-script=$STYLE_LUA --number-processes=6 --cache-strategy=dense changes.osc.gz`

$STYLE and $STYLE_LUA are the files from the openstreetmap carto file.

change.osm.gz contains a one minute diff from ~ 2018-04-28 14:15



-- 
You are receiving this because you are subscribed to this thread.
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/issues/846#issuecomment-385454867
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20180430/e8a8e9cd/attachment.html>