Conversation
𝄞𝖆𝖓𝖓𝖆𝖒𝖆𝖗𝖎𝖆
annamaria@shrimptest.bedwetting.club
db rot is real guys db rot killed my family & then looked at me & said “you’re next” & then i screamed & then i woke up
1
2
6
@annamaria your instance db was never vacuumed btw ,
3
1
2
@fiore THIS ISNT MY INSTANCE I DONT RUN THIS INSTANCE
1
0
1
@annamaria ???youre tye only user ???
2
0
1
auntie monkey
monkey@greatape.casa@fiore @annamaria I never have with my instance. I'm just running on SQLite and a dream.
1
0
0
@monkey @annamaria bedwetting is running on postgres i think ? idk anna knows
0
0
0
@fiore im migrating full time full stop right now
1
0
0
@annamaria nonono anna please no dont ill stop i promise
0
0
0
@lena @annamaria oh wait .. so lena is the admin!
0
0
1
@snacks @annamaria oh u sure ? netshrimp docs say i should set up a cronjob for it
1
0
0
Snacks
snacksautovacuum (boolean)
Controls whether the server should run the autovacuum launcher daemon. This is on by default
yeah
2
0
0
Phantasm
phnt@fluffytail.org
@snacks @fiore @annamaria That's only marking dead rows for overwrite, but if the storage backend can't actually fill those gaps in the files, it will append it at the end. Eventually you will have to vacuum full/pg_repack the database manually.
1
0
3
Snacks
snacks
@phnt @fiore @annamaria just have enough storage that you always end up with a large enough gap before running out of space 
1
0
3
Phantasm
phnt@fluffytail.org
@snacks @fiore @annamaria Yeah I know, just wanted to put that out since the thread is about db meme rot (never running vacuum full).
1
0
3
Snacks
snacks
@phnt @fiore @annamaria this server has never seen a vacuum full, much less a repack, and people are amazed at how fast it runs lmao (but that's just because it's overspecced to hell and back)
1
0
2
Phantasm
phnt@fluffytail.org
@snacks @fiore @annamaria You aren't running on shit tier VPS hardware with IO performance worse than an IDE HDD from the 90's. That's the magic sauce.
1
1
4
Snacks
snacks
@phnt @fiore @annamaria no amount of vacuuming, repacking and tuning got the shitty hetzner network storage to be fast enough. That's kinda why i'm hosting at home now
1
0
1
Phantasm
phnt@fluffytail.org
@snacks @fiore @annamaria Yeah, that is mostly hopeless. Same with BuyVM's storage slabs. I had a 15GB read/write lvmcache in front of it and it still kept falling over. But pl.borked.technology temporarily runs on a Hetzner VPS and the IO on the main SSD is actually pretty good.
0
0
3