[Tile-serving] osm2pg OOM

Paul Norman penorman at mac.com
Fri Oct 9 21:00:14 UTC 2015


On 10/9/2015 1:52 PM, Alex O'Ree wrote:
>> >Is updating the database afterwards with changes important?
> yes
How often do you need to update? Do you need minutely/hourly updates, or 
is a periodic reloading of the database every month okay?
>> >Have you tried a smaller data extract, or does the problem occur no matter how little data you try and load?
> Not yet, no.

Test with a small extract.

>> >Do you have an option (such as with a virtual machine) to easily allocate more memory to it?
> It's in a VM at the moment with like 4GB ram.

A 4GB VM is not a suitable database server for holding the planet. Even 
after importing, rendering will be horribly slow.

What is your osm2pgsql command line, and how does it differ from what 
osm2pgsql -h suggests?





More information about the Tile-serving mailing list