Conversation

Notices

1. Embed this notice
   quality floof 🏳️‍🌈🦊 (flisk@fops.cloud)'s status on Tuesday, 10-Sep-2024 23:25:52 JST quality floof 🏳️‍🌈🦊
   question for akkoma admins: do you regularly prune old remote posts[1] from your db? if so, do you see any improvements in database size from this? what's the performance of these prune runs like?
   
   asking because the benefits i'm seeing are kind of dubious and the performance is ridiculously awful. i'm not sure i'm supposed to be using this
   
   [1] https://docs.akkoma.dev/stable/administration/CLI_tasks/database/#prune-old-remote-posts-from-the-database
   • Embed this notice
     on-lain ✔ᵛᵉʳᶦᶠᶦᵉᵈ (lain@lain.com)'s status on Tuesday, 10-Sep-2024 23:25:50 JST on-lain ✔ᵛᵉʳᶦᶠᶦᵉᵈ

     in reply to
     @flisk don't do it, it doesn't help. I really want to remove it from pleroma. it's defragmentation for *oma instances.
   • Embed this notice
     on-lain ✔ᵛᵉʳᶦᶠᶦᵉᵈ (lain@lain.com)'s status on Tuesday, 10-Sep-2024 23:28:13 JST on-lain ✔ᵛᵉʳᶦᶠᶦᵉᵈ

     in reply to

     • THOT POLICE
     @s8n @flisk yeah, that obviously works. or just removing everything older than 6 months or so.
   • Embed this notice
     THOT POLICE (s8n@posting.lolicon.rocks)'s status on Tuesday, 10-Sep-2024 23:28:14 JST THOT POLICE

     in reply to

     • on-lain ✔ᵛᵉʳᶦᶠᶦᵉᵈ
     @lain @flisk I don't notice any benefits but I do notice benefits from occasionally wiping all activities from the whole db
   • Embed this notice
     on-lain ✔ᵛᵉʳᶦᶠᶦᵉᵈ (lain@lain.com)'s status on Tuesday, 10-Sep-2024 23:29:50 JST on-lain ✔ᵛᵉʳᶦᶠᶦᵉᵈ

     in reply to

     • 「セル」cell (سل)
     @cell @flisk the most important thing is to set the postgres settings correctly and if possible run the most recent postgres version. i never repack or delete or whatever on my servers, and even soykaf (the longest running pleroma instance) runs perfectly fine on a regular hetzner machine.
   • Embed this notice
     「セル」cell (سل) (cell@pl.ebin.zone)'s status on Tuesday, 10-Sep-2024 23:29:51 JST 「セル」cell (سل)

     in reply to

     • on-lain ✔ᵛᵉʳᶦᶠᶦᵉᵈ
     @lain @flisk so uh i’ve been doing pg_repack and it’s kinda taken care of things somewhat, db size is now 15GB for a smol single user instance running for two years..