[Tile-serving] osm2pg OOM

[Alex O'Ree]

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?

On Fri, Oct 9, 2015 at 5:00 PM, Paul Norman <penorman at mac.com> wrote:
> 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?
>
>
>
>
> _______________________________________________
> Tile-serving mailing list
> Tile-serving at openstreetmap.org
> https://lists.openstreetmap.org/listinfo/tile-serving