Screenshot_20231003_191413.png

Notices where this attachment appears

1. Embed this notice
    (mint@ryona.agency)'s status on Wednesday, 04-Oct-2023 01:19:26 JST 

   in reply to
   @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