matrix07012 @matrix@gameliberty.club

Sorry for the downtime. I was updating but database backup takes a long time and then Github fucked my repo because it forcefully renamed master to main and then I forgot a comma

When one non-gender specific parent identifying folk loves another non-gender specific parent identifying folk very much, they socially construct some gametes and consensually combine them.

@Mek101
Me neither

What if she consents

@smugumin
He just worded it poorly. Still pretty funny though.

@sjw
100GB Mastodon and 40GB Misskey

@redneonglow
It transcodes it based on how you set it. I have it on default

@Moon
I assume it's better for CPU usage when serving AP activities because it doesn't have to create it, just queries the db and serves it?
@lewdthewides

@solarsailor
I thought it should be usef to some latency since the initial release was all the way back when SSDs weren't a thing (I think)

@Moon
Mastodon seems to be more efficient with DB usage than Pleroma, however since server has NVME all the queries are mostlikely CPU bound which means it could perform worse.
I might copy the DB to my PC, spin up VM to test it first.
I have a NVME drive and the same CPU architecture so it should show conclusive results.
@lewdthewides

@solarsailor
I have 3 3900X threads. I don't think it should handle it ok.

@Moon
How big is it a CPU hit? My Masto VPS only really gets pinned when someone posts a bigger non x264 video and it starts transcoding
@lewdthewides

@rin
100GB Masto backup takes up 17GB and 40GB Misskey takes up 5GB. I'm pretty sure pg_dump doesn't include indexes though.
@feld

@thatbrickster
Yeah, but it barely works as a phone and the hardware is weak. Even if the project matures I doubt they will make a powerful phone for it.
@Rynach

@lewdthewides
That costs money
@Moon

@Moon
Thanks for that. I'm going to look it up. Normally I wouldn't touch Postgres at all.