A further update after more discussion with our host-
The major factor at play here is the increase in scrapers/bots/AI traffic to servers hosting federated content. There are large waves of bot requests that are pushing the postgres service to capacity across multiple customer sites within our host's infrastructure. Our host blocks most scrapers automatically, and is actively working to block new bots to minimize the impact of the increased traffic as much as possible. Despite those efforts we're still experiencing some problems here and there that we hope to have solved after the upgrades this weekend.
Again, thank you for understanding.