l4p1n on Nostr: A question to admins of Mastodon instances with a large database (the one I help with ...
A question to admins of Mastodon instances with a large database (the one I help with has surpassed 100 GB).
How do you tune your database such as the largest tables (statuses, conversations, preview_cards, etc…) are vacuumed regularly so they don't end up wasting too much space ?
I tried looking on the internet and in the docs, not much to be found 🤔
#mastoadmin #postgresql
Published at
2025-05-23 10:14:40Event JSON
{
"id": "09ff23115b0e5218887e86997f69190ec56c6e826303d5fde173bb97a833ec32",
"pubkey": "4697624088045c657ea98b761fdc566708b7f3a5e536d8dd604d926a79344c2b",
"created_at": 1747995280,
"kind": 1,
"tags": [
[
"t",
"mastoadmin"
],
[
"t",
"postgresql"
],
[
"imeta",
"url https://furry.engineer/system/media_attachments/files/114/556/562/873/339/771/original/808ddd7bb234af1f.png",
"m image/png",
"dim 463x111",
"blurhash U26t{]-;~q_2IUD%D%D%xuM{M{D%xuWBofRj"
],
[
"proxy",
"https://furry.engineer/users/l4p1n/statuses/114556618681906403",
"activitypub"
],
[
"client",
"Mostr",
"31990:6be38f8c63df7dbf84db7ec4a6e6fbbd8d19dca3b980efad18585c46f04b26f9:mostr",
"wss://relay.mostr.pub"
]
],
"content": "A question to admins of Mastodon instances with a large database (the one I help with has surpassed 100 GB).\n\nHow do you tune your database such as the largest tables (statuses, conversations, preview_cards, etc…) are vacuumed regularly so they don't end up wasting too much space ?\n\nI tried looking on the internet and in the docs, not much to be found 🤔 \n\n#mastoadmin #postgresql\n\nhttps://furry.engineer/system/media_attachments/files/114/556/562/873/339/771/original/808ddd7bb234af1f.png",
"sig": "19740ab1448149733db3aaa41a1d498d911241eb6cc8caf4aee5265552ac8cde71758dbcaa043f97e00e25fd94063117680971127d7465519de827dfca8ff3a2"
}
