<p><a class="user-mention" data-hovercard-user-id="471535" data-octo-click="hovercard-link-click" data-octo-dimensions="link_type:self" href="https://github.com/jnewmoyer">@jnewmoyer</a> :</p>
<blockquote>
<p>I discovered that I was getting an Out of Memory with osm2pgsql  ....<br>
I am doing a planet import on an EC2 instance with 16G of RAM  ....</p>
</blockquote>
<p>Try to add an extra 32Gb "Swap Space" ( ~ "double the amount of system memory". )<br>
or upgrade your EC2 instance.</p>
<h3>"Swap Space"</h3>
<p><code>One of the easiest way of guarding against out-of-memory errors in applications is to add some swap space to your server. In this guide, we will cover how to add a swap file to an Ubuntu 18.04 server.</code><br>
<a href="https://www.digitalocean.com/community/tutorials/how-to-add-swap-space-on-ubuntu-18-04" rel="nofollow">https://www.digitalocean.com/community/tutorials/how-to-add-swap-space-on-ubuntu-18-04</a></p>
<p>You can find lot of information about tunning EC2 instances</p>
<ul>
<li><a href="https://docs.aws.amazon.com/AWSEC2/latest/UserGuide/instance-store-swap-volumes.html" rel="nofollow">https://docs.aws.amazon.com/AWSEC2/latest/UserGuide/instance-store-swap-volumes.html</a></li>
<li><a href="https://docs.aws.amazon.com/AWSEC2/latest/UserGuide/disk-performance.html" rel="nofollow">https://docs.aws.amazon.com/AWSEC2/latest/UserGuide/disk-performance.html</a></li>
<li>...</li>
</ul>
<h3>osm2pgsql community benchmarks / settings :</h3>
<p><a href="https://wiki.openstreetmap.org/wiki/Osm2pgsql/benchmarks" rel="nofollow">https://wiki.openstreetmap.org/wiki/Osm2pgsql/benchmarks</a><br>
( you can add your benchmarks )</p>

<p style="font-size:small;-webkit-text-size-adjust:none;color:#666;">—<br />You are receiving this because you are subscribed to this thread.<br />Reply to this email directly, <a href="https://github.com/openstreetmap/osm2pgsql/issues/855#issuecomment-404119521">view it on GitHub</a>, or <a href="https://github.com/notifications/unsubscribe-auth/AD2-7v-g3edIKT-KSmvHxqn6wqNT1RSMks5uFdD9gaJpZM4VAAIJ">mute the thread</a>.<img src="https://github.com/notifications/beacon/AD2-7pqa55XywpHRnugQzYCIFm4nIxvsks5uFdD9gaJpZM4VAAIJ.gif" height="1" width="1" alt="" /></p>
<script type="application/json" data-scope="inboxmarkup">{"api_version":"1.0","publisher":{"api_key":"05dde50f1d1a384dd78767c55493e4bb","name":"GitHub"},"entity":{"external_key":"github/openstreetmap/osm2pgsql","title":"openstreetmap/osm2pgsql","subtitle":"GitHub repository","main_image_url":"https://assets-cdn.github.com/images/email/message_cards/header.png","avatar_image_url":"https://assets-cdn.github.com/images/email/message_cards/avatar.png","action":{"name":"Open in GitHub","url":"https://github.com/openstreetmap/osm2pgsql"}},"updates":{"snippets":[{"icon":"PERSON","message":"@ImreSamu in #855: @jnewmoyer :\r\n\u003eI discovered that I was getting an Out of Memory with osm2pgsql  ....\r\n\u003eI am doing a planet import on an EC2 instance with 16G of RAM  ....\r\n\r\nTry to add an extra 32Gb \"Swap Space\" ( ~ \"double the amount of system memory\". ) \r\nor upgrade your EC2 instance.\r\n\r\n### \"Swap Space\" \r\n`One of the easiest way of guarding against out-of-memory errors in applications is to add some swap space to your server.\r\nIn this guide, we will cover how to add a swap file to an Ubuntu 18.04 server.`\r\nhttps://www.digitalocean.com/community/tutorials/how-to-add-swap-space-on-ubuntu-18-04\r\n\r\nYou can find lot of information about tunning EC2 instances\r\n* https://docs.aws.amazon.com/AWSEC2/latest/UserGuide/instance-store-swap-volumes.html\r\n* https://docs.aws.amazon.com/AWSEC2/latest/UserGuide/disk-performance.html\r\n* ...\r\n\r\n\r\n### osm2pgsql community benchmarks / settings :\r\n\r\nhttps://wiki.openstreetmap.org/wiki/Osm2pgsql/benchmarks\r\n( you can add your benchmarks )\r\n\r\n"}],"action":{"name":"View Issue","url":"https://github.com/openstreetmap/osm2pgsql/issues/855#issuecomment-404119521"}}}</script>
<script type="application/ld+json">[
{
"@context": "http://schema.org",
"@type": "EmailMessage",
"potentialAction": {
"@type": "ViewAction",
"target": "https://github.com/openstreetmap/osm2pgsql/issues/855#issuecomment-404119521",
"url": "https://github.com/openstreetmap/osm2pgsql/issues/855#issuecomment-404119521",
"name": "View Issue"
},
"description": "View this Issue on GitHub",
"publisher": {
"@type": "Organization",
"name": "GitHub",
"url": "https://github.com"
}
},
{
"@type": "MessageCard",
"@context": "http://schema.org/extensions",
"hideOriginalBody": "false",
"originator": "AF6C5A86-E920-430C-9C59-A73278B5EFEB",
"title": "Re: [openstreetmap/osm2pgsql] Planet load fails with ERROR: relation \"osm_point\" does not exist (#855)",
"sections": [
{
"text": "",
"activityTitle": "**ImreSamu**",
"activityImage": "https://assets-cdn.github.com/images/email/message_cards/avatar.png",
"activitySubtitle": "@ImreSamu",
"facts": [

]
}
],
"potentialAction": [
{
"name": "Add a comment",
"@type": "ActionCard",
"inputs": [
{
"isMultiLine": true,
"@type": "TextInput",
"id": "IssueComment",
"isRequired": false
}
],
"actions": [
{
"name": "Comment",
"@type": "HttpPOST",
"target": "https://api.github.com",
"body": "{\n\"commandName\": \"IssueComment\",\n\"repositoryFullName\": \"openstreetmap/osm2pgsql\",\n\"issueId\": 855,\n\"IssueComment\": \"{{IssueComment.value}}\"\n}"
}
]
},
{
"name": "Close issue",
"@type": "HttpPOST",
"target": "https://api.github.com",
"body": "{\n\"commandName\": \"IssueClose\",\n\"repositoryFullName\": \"openstreetmap/osm2pgsql\",\n\"issueId\": 855\n}"
},
{
"targets": [
{
"os": "default",
"uri": "https://github.com/openstreetmap/osm2pgsql/issues/855#issuecomment-404119521"
}
],
"@type": "OpenUri",
"name": "View on GitHub"
},
{
"name": "Unsubscribe",
"@type": "HttpPOST",
"target": "https://api.github.com",
"body": "{\n\"commandName\": \"MuteNotification\",\n\"threadId\": 352322057\n}"
}
],
"themeColor": "26292E"
}
]</script>