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

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 week ago

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 week 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.

this post was submitted on 04 Jul 2024
110 points (99.1% liked)

Lemmy.ca's Main Community

2758 readers
25 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