Got a lot of "Failed to backfill 'Reader' badge" errors

[JammyDodger]

That does seem like a beefy one.

On the off-chance you didn’t do this at the time (depending on how old your forum is), there was this advice given in the PostgreSQL 13 update

@fitzy

Re-creating the indexes

This upgrade main feature is great file savings in our largest table in every instance, the post_timings table and it’s indexes. After doing a successful update you will need to run a command to re-build the indexes and reap the benefits.

cd /var/discourse
./launcher enter app
su postgres
psql
\connect discourse
REINDEX SCHEMA CONCURRENTLY public;
\q
exit
exit

If you can check the post_timings size before and after the REINDEX that would be a cool stat to share here!

Unfortunately I don’t have any direct experience of this so we may need to wait for someone smart to show up for a deeper dive.