Lemmy.ca's Main Community

2799 readers

2 users here now

Welcome to lemmy.ca's c/main!

Since everyone on lemmy.ca gets subscribed here, this is the place to chat about the goings on at lemmy.ca, support-type items, suggestions, etc.

Announcements can be found at https://lemmy.ca/c/meta

For support related to this instance, use https://lemmy.ca/c/lemmy_ca_support

founded 3 years ago

MODERATORS

[email protected]

109

Lemmy.ca scheduled maintenance Saturday July 6th - Complete (lemmy.ca)

submitted 1 month ago* (last edited 1 month ago) by [email protected] to c/[email protected]

19 comments fedilink hide all child comments

Hi everyone,

We'll be undergoing maintenance on Saturday morning from about 11am - noon PST.

We've been having some stability issues over the past few days that I've tracked down to database performance, so I'll be doing some tuning and also applying all our needed system updates at the same time.

Cheers!

Update: This is all done now!

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

[–] [email protected] 2 points 1 month ago (1 children)

I would love to see a write up on what was done. PostgeSQL is my favourite system and I would like to know more.

[–] [email protected] 1 points 1 month ago

Nothing too crazy. My discovery this week is that our custom postgres conf actually wasn't being applied and I had never noticed. It got fixed a while ago but I haven't been following the upstream ansible repo - https://github.com/LemmyNet/lemmy-ansible/commit/22aa431a3d1ed8437a418633e9d92ae4af45bbf5

So just fixing up postgres to actually use the conf with our tuned wal & worker settings, along with the usual apt-get update/upgrade/reboot.