I did notice the website going in and out all night.
Also the number of federated posts just jumped big time. We were at something like Ninety thousand total just a couple weeks ago and now we're at over 125,000 new OPs.
Good chance it's just increased usage from all the new federated users. Sounds like the lemmy devs have a plan to optimize things. There may be some low hanging fruit optimization we can look into doing with the postgres config. I'll try to find some time into reading the current default configs.
V17 has been a disaster. This could in part be caused by active Lemmyverse users increasing by a factor of 20 in the last month. It could also be some of the new instances we federated with trying some funky stuff.
In any case I know the devs are working very hard. I have never seen do many different people contributing to the development effort.
So despite these scaling problems, the future looks bright.