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.

Credits

Icon base by Lorc under CC BY 3.0 with modifications to add a gradient

founded 2 years ago

MODERATORS

snowe

Ategon

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 😂

top 6 comments

sorted by: hot top controversial new old

[–] erlingur 2 points 1 year ago

Seems to work fine for me at least :) I had an issue earlier today when I tried to create a post but the one I just created worked perfectly.

[–] [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.

load more comments

Programming.dev Meta

Links

Credits