<p>The fastest way to complete this import is buying a 512 GB SSD drive with next-day delivery, putting that into your server tomorrow, and then restarting the import. Re. the "hand-crafted Mercator conversion", OSM data needs to be converted into "sphercial Mercator" coordinates when imported. "-m" uses built-in C/C++ code to make this conversion, whereas "-E 3857" uses an external library (proj4) to do the same, hence it will be slightly slower. But frankly I don't believe it will make a difference in your case since you've got plenty of CPU idly waiting for the disk to complete an operation.</p>

<p style="font-size:small;-webkit-text-size-adjust:none;color:#666;">—<br />You are receiving this because you commented.<br />Reply to this email directly, <a href="https://github.com/openstreetmap/osm2pgsql/issues/676#issuecomment-274421459">view it on GitHub</a>, or <a href="https://github.com/notifications/unsubscribe-auth/AD2-7uIHUYDKJrQ2o4SAawkt_Km-Aqtwks5rVF0vgaJpZM4LqfbO">mute the thread</a>.<img alt="" height="1" src="https://github.com/notifications/beacon/AD2-7lGfnvvlNsFgsKWOetlRhl73T4bdks5rVF0vgaJpZM4LqfbO.gif" width="1" /></p>
<div itemscope itemtype="http://schema.org/EmailMessage">
<div itemprop="action" itemscope itemtype="http://schema.org/ViewAction">
  <link itemprop="url" href="https://github.com/openstreetmap/osm2pgsql/issues/676#issuecomment-274421459"></link>
  <meta itemprop="name" content="View Issue"></meta>
</div>
<meta itemprop="description" content="View this Issue on GitHub"></meta>
</div>

<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://cloud.githubusercontent.com/assets/143418/17495839/a5054eac-5d88-11e6-95fc-7290892c7bb5.png","avatar_image_url":"https://cloud.githubusercontent.com/assets/143418/15842166/7c72db34-2c0b-11e6-9aed-b52498112777.png","action":{"name":"Open in GitHub","url":"https://github.com/openstreetmap/osm2pgsql"}},"updates":{"snippets":[{"icon":"PERSON","message":"@woodpeck in #676: The fastest way to complete this import is buying a 512 GB SSD drive with next-day delivery, putting that into your server tomorrow, and then restarting the import. Re. the \"hand-crafted Mercator conversion\", OSM data needs to be converted into \"sphercial Mercator\" coordinates when imported. \"-m\" uses built-in C/C++ code to make this conversion, whereas \"-E 3857\" uses an external library (proj4) to do the same, hence it will be slightly slower. But frankly I don't believe it will make a difference in your case since you've got plenty of CPU idly waiting for the disk to complete an operation."}],"action":{"name":"View Issue","url":"https://github.com/openstreetmap/osm2pgsql/issues/676#issuecomment-274421459"}}}</script>