[Tile-serving] [openstreetmap/osm2pgsql] OOM killed while building index on table planet_osm_rels (#834)

[Sarah Hoffmann]

I think this memory issue has already been fixed in a recent series of PRs (#612, #813, #814). These changes are not yet available in the osm2pgsql version shipped with the latest Nominatim release. If you want to confirm that the latest version works, you'll need to compile a osm2pgsql master version and temporarily replace the osm2pgsql binary via `@define('CONST_Osm2pgsql_Binary', '<path to som2pgsql>')` in your Nominatim `settings/local.php`.

The Nominatim documentation currently states the following with regard to the caching parameter: "As a rule of thumb, this should be about the same size as the file you are importing but never more than 2/3 of RAM available." The 2/3 are slightly conservative but should work for most postgresql settings (even without the PRs above) and I'm reluctant to extend the explanation as I fear that it will be read by even less people.

-- 
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/834#issuecomment-376671360
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20180327/ec6e0ad5/attachment.html>