Office hours this Thursday at 16:00 UTC

Tried this on a staging copy first and it behaved exactly as described. Confident enough to roll it to production now.

Thanks for writing this up. Bookmarking it — the kind of thing I will want to reference again in a month.

This is the answer I wish I had found six months ago. Would have saved me a weekend of trial and error.

One caveat for larger communities: keep an eye on the indexes. At a few thousand rows the difference is night and day.

Could you say more about how you measured the result? I want to try this but I am not sure what success would look like.