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

[vshcherb]

After upgrade to 18.04 from 14.04, osm2pgsql had to be recompiled due to broken libraries. Before I was able to use -C 16000 and it never used more than 24 GB of Ram. Today I ran exactly same parameters  and I see these situation:
```
 6426 postgres  20   0  0.132t 0.072t   3172 D   7.3 78.7  45:31.48 osm2pgsql --append --style /usr/local/share/osm2pgsql/default.style -k --flat-+
```
I could definitely say that postgresql didn't change and work as before 9.1 and I don't see any tile generation degradation.

The full line is here command https://github.com/osmandapp/OsmAnd-misc/blob/master/config/mapnik_update.sh#L13

If you can tell what information is possible to provide that would be great. I'm afrad reimport will not solve the problem cause the changeset diff I'm trying to load is just 3 MB.

The biggest mystery that RAM is 4 times more than expected.

-- 
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-404971550
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20180713/5f06a423/attachment.html>