I'm trying to get the instance to run better, so I just adjusted the database pooling to hopefully make things run more stable. Let me know if it made stuff worse 😂
I'm trying to get the instance to run better, so I just adjusted the database pooling to hopefully make things run more stable. Let me know if it made stuff worse 😂
6 Comments
eternaldeiwos@lm.qtt.no · 2 pts · 3y
Could you share what you did?
pgbouncerand a much larger pool of available connections comes to mind.snowe@programming.dev · 1 pts · 3y
All I did so far was up the pool connections from lemmy. I am quite bad at db stuff, so if you want to help me set up pgbouncer I'd love the help. I had been considering, but hadn't gotten around to it yet.
eternaldeiwos@lm.qtt.no · 2 pts · 3y
Depends on how you're currently set up. My intention was to use something like k3s + https://cloudnative-pg.io to handle most of the details for me.
I prefer to version my configs so this approach serves my MO better, even if it is a little more work initially.
Perhyte@lemmy.world · 1 pts · 3y
The new Lemmy release (0.17.4) also contains some DB optimizations according to the release notes.
snowe@programming.dev · 1 pts · 3y
Yes. I've been meaning to update, but the script was failing so I need to look into that first.