[Tile-serving] [openstreetmap/osm2pgsql] Dead Lock in Europe data file import (#779)

[Paul Norman]

It's extremely unlikely to be a deadlock, but you can check that with the `pg_stat_activity` table.

The `planet_osm_ways` nodes index is the biggest and tags the longest, but it shouldn't take that long. It sounds like it's gone into swap and you have slow disks.

You need to look at what is using RAM, what is using swap, and what is being swapped in and out. 14000 MB is too high for the node cache on a machine with only 15GB of RAM.0

Other recommendations would be
- Use at least PostgreSQL 9.3, since it's faster at this work
- Tune your postgres appropriately for dealing with large amounts of data

If possible, get more RAM and faster drives.

-- 
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/779#issuecomment-320817659
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20170807/0d3ec02d/attachment.html>