<p>psql settings:</p>

<pre><code>max_connections = 300 
effective_cache_size = 96GB
shared_buffers = 512MB
work_mem = 1536MB
maintenance_work_mem = 4GB
wal_buffers = 16MB
checkpoint_segments = 1600
checkpoint_completion_target = 0.9
random_page_cost = 1.1
cpu_tuple_cost = 0.05
effective_io_concurrency = 15

fsync = off
full_page_writes = off
synchronous_commit = off

autovacuum = on
autovacuum_vacuum_scale_factor = 0.05
autovacuum_analyze_scale_factor = 0.2

shared_preload_libraries = 'auto_explain'
auto_explain.log_min_duration = '5s'
</code></pre>

<p style="font-size:small;-webkit-text-size-adjust:none;color:#666;">—<br>Reply to this email directly or <a href="https://github.com/openstreetmap/osm2pgsql/issues/517#issuecomment-164526202">view it on GitHub</a>.<img alt="" height="1" src="https://github.com/notifications/beacon/AD2-7jI0nBBzttEAd0Wt3HVglucLYATIks5pPwkJgaJpZM4G1Ass.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/517#issuecomment-164526202"></link>
  <meta itemprop="name" content="View Issue"></meta>
</div>
<meta itemprop="description" content="View this Issue on GitHub"></meta>
</div>