<p dir="auto">This simplifies the code, because we don't have to decide whether to set this or not on each connection. And it doesn't matter much when setting this for read-only connections which don't need this.</p>
<p dir="auto">Setting synchronous_commit = off speeds up writing to the database, because commis are not delayed until the WAL is written to disk. It can not lead to corruption of the database.</p>
<p dir="auto"><a href="https://www.postgresql.org/docs/current/runtime-config-wal.html#GUC-SYNCHRONOUS-COMMIT" rel="nofollow">https://www.postgresql.org/docs/current/runtime-config-wal.html#GUC-SYNCHRONOUS-COMMIT</a></p>

<hr>

<h4>You can view, comment on, or merge this pull request online at:</h4>
<p>  <a href='https://github.com/osm2pgsql-dev/osm2pgsql/pull/2131'>https://github.com/osm2pgsql-dev/osm2pgsql/pull/2131</a></p>

<h4>Commit Summary</h4>
<ul>
  <li><a href="https://github.com/osm2pgsql-dev/osm2pgsql/pull/2131/commits/8648488da218088d5b9ad8738a7a496eced94ed0" class="commit-link">8648488</a>  Disable synchronous commit on all connections</li>
</ul>

<h4 style="display: inline-block">File Changes </h4> <p style="display: inline-block">(<a href="https://github.com/osm2pgsql-dev/osm2pgsql/pull/2131/files">4 files</a>)</p>
<ul>
  <li>
    <strong>M</strong>
    <a href="https://github.com/osm2pgsql-dev/osm2pgsql/pull/2131/files#diff-037c31cfecf376a564eabe2b2ced673d2d0173405b58ce85a83fdc51a4f348c3">src/db-copy.cpp</a>
    (3)
  </li>
  <li>
    <strong>M</strong>
    <a href="https://github.com/osm2pgsql-dev/osm2pgsql/pull/2131/files#diff-1805c9b742d8d030a8d1eb13c8ef3f89183c40f71eecb646e591c7cd0c1d2b24">src/flex-table.cpp</a>
    (1)
  </li>
  <li>
    <strong>M</strong>
    <a href="https://github.com/osm2pgsql-dev/osm2pgsql/pull/2131/files#diff-f90c5943abe16bc4978288b3ea8c56947a7661461653579b9c0b44b1c342ed92">src/pgsql.cpp</a>
    (5)
  </li>
  <li>
    <strong>M</strong>
    <a href="https://github.com/osm2pgsql-dev/osm2pgsql/pull/2131/files#diff-b88247c729c0441b6bab3e9885aaadb052278b7e495af54f9f9f5cb0b852990a">src/table.cpp</a>
    (2)
  </li>
</ul>

<h4>Patch Links:</h4>
<ul>
  <li><a href='https://github.com/osm2pgsql-dev/osm2pgsql/pull/2131.patch'>https://github.com/osm2pgsql-dev/osm2pgsql/pull/2131.patch</a></li>
  <li><a href='https://github.com/osm2pgsql-dev/osm2pgsql/pull/2131.diff'>https://github.com/osm2pgsql-dev/osm2pgsql/pull/2131.diff</a></li>
</ul>

<p style="font-size:small;-webkit-text-size-adjust:none;color:#666;">—<br />Reply to this email directly, <a href="https://github.com/osm2pgsql-dev/osm2pgsql/pull/2131">view it on GitHub</a>, or <a href="https://github.com/notifications/unsubscribe-auth/AA6353TLNOF5CSPPGX5ENSLYRS3QFAVCNFSM6AAAAABCWNEX42VHI2DSMVQWIX3LMV43ASLTON2WKOZSGEYTINJWGMZTQOA">unsubscribe</a>.<br />You are receiving this because you are subscribed to this thread.<img src="https://github.com/notifications/beacon/AA6353S4L4UQQE5X6XOTPTLYRS3QFA5CNFSM6AAAAABCWNEX42WGG33NNVSW45C7OR4XAZNFJFZXG5LFVJRW63LNMVXHIX3JMTHH4CNNHQ.gif" height="1" width="1" alt="" /><span style="color: transparent; font-size: 0; display: none; visibility: hidden; overflow: hidden; opacity: 0; width: 0; height: 0; max-width: 0; max-height: 0; mso-hide: all">Message ID: <span><osm2pgsql-dev/osm2pgsql/pull/2131</span><span>@</span><span>github</span><span>.</span><span>com></span></span></p>
<script type="application/ld+json">[
{
"@context": "http://schema.org",
"@type": "EmailMessage",
"potentialAction": {
"@type": "ViewAction",
"target": "https://github.com/osm2pgsql-dev/osm2pgsql/pull/2131",
"url": "https://github.com/osm2pgsql-dev/osm2pgsql/pull/2131",
"name": "View Pull Request"
},
"description": "View this Pull Request on GitHub",
"publisher": {
"@type": "Organization",
"name": "GitHub",
"url": "https://github.com"
}
}
]</script>