[Tile-serving] osm2pg OOM

[Paul Norman]

On 10/9/2015 2:13 PM, Alex O'Ree wrote:
> For right now, I'm just trying to import the data, then I'll migrate
> the VM to a more appropriate piece of hardware. I'm not intending on
> rendering from that VM.
>
> How much ram do I actually need?

32GB is enough to fit all nodes into RAM. You can work with 16GB. With 
8GB, I wouldn't consume updates but do a dump and reload. With 
insufficient ram, consuming updates causes rendering data to get flushed 
from RAM caches.

You can make osm2pgsql work on 4GB, or even on 1GB, but performance is 
going to be terrible handling 350-450 GB databases.

For rendering, it depends on what load. In a high-volume production 
environment, you want enough RAM to keep most of the data in cache, so 
I'd probably spec 128GB+. The rendering indexes are about 40-48GB, 
depending on custom indexes. My dev box has 32GB, and that's plenty for 
my rendering work. My public server has 8GB of RAM but I don't render 
from a full planet on it.