@Gargron 👍 Nice to know what might be just ahead of ourselves mid- to long-term.
And since mastodon.social keeps lagging occasionally: if the DB server turns out to be the culprit, have you considered or even tried using a CockroachDB cluster as a drop-in replacement for PostgreSQL? Can you think of any obstacles?