[Tile-serving] Osm2pgsql import / Cache Issues

Peter Körner osm-lists at mazdermind.de
Tue Feb 11 15:15:28 UTC 2014


Hi

Am 11.02.2014 13:01, schrieb Sn4fu AsUsual:
> Going over pending ways
> pending_ways failed: out of memory for query result
> (7)
> Error occurred, cleaning up

"for query result" sounds like an postgresql error message. Did you
extend the postgres memory setup?

Like in "Tuning postgresql" on
<http://switch2osm.org/serving-tiles/manually-building-a-tile-server-12-04/>

I'm currently importing a planet on a machine with 24G RAM.
I set -C to 16000, enabled slim and flatnodes, set maintenance_work_mem
= 512MB and shared_buffers = 2GB.

That seemd a little too much, I guess -C 10000 would have been better to
have a little more headroom.

Peter




More information about the Tile-serving mailing list