Conversation

Notices

1. Embed this notice
   on-lain ✔ᵛᵉʳᶦᶠᶦᵉᵈ (lain@lain.com)'s status on Wednesday, 29-May-2024 00:32:04 JST on-lain ✔ᵛᵉʳᶦᶠᶦᵉᵈ
   Just because it recently came up again, if you run a Pleroma/Akkoma server and have NOT adjusted your postgresql configuration, you WILL run into performance issues after a certain database size.
   
   It's easy to change, check https://docs.pleroma.social/backend/configuration/postgresql/ on what to do.
   • kaia, snacks and Pleroma-tan like this.
   • Pleroma-tan repeated this.
   • Embed this notice
     「セル」cell (سل) (cell@pl.ebin.zone)'s status on Wednesday, 29-May-2024 00:39:22 JST 「セル」cell (سل)

     in reply to
     @lain :cat_si:👍
     ebin zone survived the 2.4 performance regressions this way but still keeps the tweaks and so far it runs smoothly :heheLain:
     on-lain ✔ᵛᵉʳᶦᶠᶦᵉᵈ and Pleroma-tan like this.
   • Embed this notice
     on-lain ✔ᵛᵉʳᶦᶠᶦᵉᵈ (lain@lain.com)'s status on Wednesday, 29-May-2024 00:42:44 JST on-lain ✔ᵛᵉʳᶦᶠᶦᵉᵈ

     in reply to

     • quality floof 🏳️‍🌈🦊
     @flisk no, it refers to the other changes
     snacks and Pleroma-tan like this.
   • Embed this notice
     quality floof 🏳️‍🌈🦊 (flisk@fops.cloud)'s status on Wednesday, 29-May-2024 00:42:46 JST quality floof 🏳️‍🌈🦊

     in reply to
     @lain this is specifically referring to disabling generic query plans, right?
     Pleroma-tan likes this.
     Pleroma-tan repeated this.
   • Embed this notice
     snacks (snacks@netzsphaere.xyz)'s status on Wednesday, 29-May-2024 01:18:46 JST snacks

     in reply to

     • quality floof 🏳️‍🌈🦊
     @lain @flisk pgtune somehow made everything even worse on the old hetzner box
   • Embed this notice
     on-lain ✔ᵛᵉʳᶦᶠᶦᵉᵈ (lain@lain.com)'s status on Saturday, 01-Jun-2024 15:18:49 JST on-lain ✔ᵛᵉʳᶦᶠᶦᵉᵈ

     in reply to

     • lamp
     @lamp yes, but the version-dependent configuration is not the critical one
   • Embed this notice
     lamp (lamp@kitty.haus)'s status on Saturday, 01-Jun-2024 15:18:50 JST lamp

     in reply to
     @lain Couldn't pleroma detect the postgres version and automatically use that config?