Programming.dev Meta

2365 readers

4 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 1 year ago

MODERATORS

[email protected]

Database optimization changes (programming.dev)

submitted 1 year ago by [email protected] to c/[email protected]

6 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

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

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

[–] Perhyte 1 points 1 year ago (1 children)

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

[–] [email protected] 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