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

Programming.dev Meta

2478 readers
1 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 2 years ago
MODERATORS
snowe
Ategon
5
Database optimization changes (self.meta)
submitted 1 year ago by snowe to c/meta
7 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 ๐Ÿ˜‚

you are viewing a single comment's thread
view the rest of the comments
[โ€“] [email protected] 2 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 1 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.

[โ€“] [email protected] 2 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.

[โ€“] [email protected] 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 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.