<p></p>
<blockquote>
<p dir="auto">Backfill the column according to <a href="https://github.com/zerebubuth/openstreetmap-cgimap/blob/2fa2d702017ddd136555e3562f574ac91870e8bc/src/osmchange_responder.cpp#L32">this order</a>. It's not necessarily correct, maybe update it later.</p>
</blockquote>
<p dir="auto">I'm not sure how feasible this is from a total runtime point of view. In any case, mass updating old element tables is probably bad news for our minutely diff replication, since it would end up generating billions of entries in our replication log files.</p>
<p dir="auto">I haven't tested it, but I believe it would bring minutely diff replication to a standstill for quite some time. The original use case for old element updates was to support redaction, which is rather low data volume. Also, we're not using this information at the moment.</p>
<p dir="auto">By the way, I'm well aware that the additional sorting in both implementations would not necessarily match the original upload sequence. However, I never really had the expectation that it should.</p>

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