Conversation

Notices

1. shitpisscum :verified: (shitpisscum@shitpisscum.mooo.com)'s status on Sunday, 26-Nov-2023 16:59:53 JST shitpisscum :verified:

   • 
   A question about pleroma's totally sensible and intuitive db schema: my /api/v1/instance/peers returns ~11000 instances but there's only ~5000 in the instances table. Where the fuck are the rest of the instances stored?
   
   cc @mint
   •  likes this.
   •  (mint@ryona.agency)'s status on Sunday, 26-Nov-2023 17:00:51 JST 

     in reply to
     @shitpisscum Interesting. I'll dig it up a little later.
   • † top dog :pedomustdie: (dcc@annihilation.social)'s status on Sunday, 26-Nov-2023 17:03:44 JST † top dog :pedomustdie:

     in reply to

     • 
     • Eric Zhang
     @mint @shitpisscum Ask @EricZhang456
   •  (mint@ryona.agency)'s status on Sunday, 26-Nov-2023 17:56:47 JST 

     in reply to

     • 
     @shitpisscum /api/v1/instance/peers calls Pleroma.Stats.get_peers(), which gets lists of peers precalculated from unique domains found in users table. Don't know what exactly instances table is used for, but most likely tracking whether instances are online in order to not send out activities to offline instances (this was a common problem with KFcc going back online after months of downtime, at least until Pleroma got patched to reset the state when receiving fresh activity).
     Screenshot_20231126_115410.png