Programming.dev Meta

2466 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

snowe@programming.dev

Ategon@programming.dev

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 😂

you are viewing a single comment's thread
view the rest of the comments

[–] eternaldeiwos@lm.qtt.no 0 points 1 year ago (4 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 (3 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.

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

load more comments (2 replies)

Programming.dev Meta

Links

Credits