[Tile-serving] Osm2pgsql import / Cache Issues

[Sn4fu AsUsual]

Well, I forgot about the postgres & kernel memory setup :/

Did it, still weird: as soon as I manually set a -C 4096 (or any other -C value), it gives me the 

Processing: Node(229580k 54.8k/s) Way(0k 0.00k/s) Relation(0 0.00/s)Error allocating nodes
Error occurred, cleaning up

error after 70 minutes..

Started the import now without a node cache (e.g. it will use the 800mb standard), which works at the moment, but it usually crashes after importing all nodes, ways & relations

Ingo

On 11 Feb 2014, at 16:15, Peter Körner <osm-lists at mazdermind.de> wrote:

> 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
> 
> 
> _______________________________________________
> Tile-serving mailing list
> Tile-serving at openstreetmap.org
> https://lists.openstreetmap.org/listinfo/tile-serving

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20140211/cb246e62/attachment.html>