<p></p>
<p dir="auto"><a class="user-mention notranslate" data-hovercard-type="user" data-hovercard-url="/users/joto/hovercard" data-octo-click="hovercard-link-click" data-octo-dimensions="link_type:self" href="https://github.com/joto">@joto</a> , reviewing the changes, I see you have put the ANALYZE call before the actual index creation. Shouldn't this be the other way around? ANALYZE needs to be able to discover the index in order for the PostgreSQL planner to have use for it.</p>
<pre class="notranslate"><code class="notranslate">table.analyze();
table.create_id_index();
</code></pre>

<p style="font-size:small;-webkit-text-size-adjust:none;color:#666;">—<br />Reply to this email directly, <a href="https://github.com/openstreetmap/osm2pgsql/pull/1675#issuecomment-1134219843">view it on GitHub</a>, or <a href="https://github.com/notifications/unsubscribe-auth/AA6353W32KMUPSLC57O3SSTVLMOBVANCNFSM5WTPPK3Q">unsubscribe</a>.<br />You are receiving this because you are subscribed to this thread.<img src="https://github.com/notifications/beacon/AA6353ROO46ABSTBVOVM7C3VLMOBVA5CNFSM5WTPPK32YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOIONNEQY.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><openstreetmap/osm2pgsql/pull/1675/c1134219843</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/openstreetmap/osm2pgsql/pull/1675#issuecomment-1134219843",
"url": "https://github.com/openstreetmap/osm2pgsql/pull/1675#issuecomment-1134219843",
"name": "View Pull Request"
},
"description": "View this Pull Request on GitHub",
"publisher": {
"@type": "Organization",
"name": "GitHub",
"url": "https://github.com"
}
}
]</script>