@yehor@mastodon.glitchy.social
2026-07-30 20:21 UTC
My careless #Mastodon database optimization paid off. I now have slow queries.
Will try to revert #postgres config to default settings and start over.
#GlitchySocial #homelab #SelfHosted #selfhosting #selfhost
Replies (2)
-
@fox@social.hostnetwork.xyz 2026-07-30 20:31
@yehor@mastodon.glitchy.social this is why i dont fuck with databases, especially postgresql
-
@yehor@mastodon.glitchy.social 2026-07-31 13:39
Oh, I just realized! This could be queries running at the moment of daily backups! I definitely should review my #Mastodon backup strategy. The only thing that needs to be backed up daily is the database, while I snapshot the whole host with suspension. #homelab #SelfHosted #selfhosting #selfhost