[Tile-serving] [openstreetmap/osm2pgsql] Planet load fails with ERROR: relation "osm_point" does not exist (#855)

[Jason Newmoyer]

I discovered that I was getting an Out of Memory with osm2pgsql. Had to look in the kernel log to see this. So I think it's just a case of an unexpected error message. 

I am doing a planet import on an EC2 instance with 16G of RAM. The machine is not doing any other work. I'm using --cache 8000 and these PG settings (mostly taken from pgtune):

default_statistics_target = '50'
maintenance_work_mem = '200MB'
checkpoint_completion_target = '0.9'
effective_cache_size = '1808MB'
work_mem = '16MB'
wal_buffers = '16MB'
shared_buffers = '448MB'
max_connections = '100'
max_wal_size = '2GB'

Any advice on how to tune memory settings between Postgres and osm2pgsql to get the best use of limited RAM, without running into OOM? 



-- 
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/855#issuecomment-403242124
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20180707/cec73116/attachment.html>