this post was submitted on 09 Jun 2023
2 points (100.0% liked)

Programming.dev Meta

2465 readers
8 users here now

Welcome to the Programming.Dev meta community!

This is a community for discussing things about programming.dev itself. Things like announcements, site help posts, site questions, etc. are all welcome here.

Links

Credits

founded 1 year ago
MODERATORS
snowe@programming.dev
Ategon@programming.dev
2
Database optimization changes (programming.dev)
submitted 1 year ago by snowe@programming.dev to c/meta@programming.dev
5 comments fedilink hide all child comments
 

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 ๐Ÿ˜‚

top 5 comments
sorted by: hot top controversial new old
[โ€“] eternaldeiwos@lm.qtt.no 0 points 1 year ago (1 children)

Could you share what you did? pgbouncer and a much larger pool of available connections comes to mind.

[โ€“] snowe@programming.dev 0 points 1 year ago (2 children)

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.

[โ€“] Perhyte@lemmy.world 1 points 1 year ago (1 children)

The new Lemmy release (0.17.4) also contains some DB optimizations according to the release notes.

[โ€“] snowe@programming.dev 1 points 1 year ago

Yes. I've been meaning to update, but the script was failing so I need to look into that first.

[โ€“] eternaldeiwos@lm.qtt.no 1 points 1 year ago* (last edited 1 year ago)

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.