@shitpisscum @7666 @shitpisscum @Economic_Hitman >I left it federating for over 2 years so the db is too big (~11.000.000 activities)
Rookie numbers.
pleroma=# select count(1) from activities;
count
----------
28892409
(1 row)That's year and a half, I think. Seems to be chugging fine on a spare PC with shitty pre-Ryzen AMD APU. So yeah, you probably need a little more RAM and clock cycles. Upgrading both postgres and pleromer would definely help, and you might also be able to spare some queries by caching objects via nginx.
Screenshot_20231003_191413.png