yeah I only keep 30 days media retention. If I want to see an image or video beyond that I'll just go to the remote instance 😂 it's so much data
Today I cleared out about 200k posts though. Freed up ~5gb of database after doing a VACUUM. Probably not worth the effort but it was a fun experiment
Mike Johnston /
npub1ey…2a2zu
2024-05-23 01:54:41
in reply to nevent1q…60gm
Author Public Key
npub1ey6gv7276ndnrjdwpjy6tzelhtyxfw9j2uxvgfez9y2evvlsgw7s62a2zuSeen on
wss://relay.nostr.bandPublished at
2024-05-23 01:54:41Event JSON
{
"id": "d6e2e04e36515eaf0ce77701526d54c82b74909504a54acc2edfe6375700bb6c",
"pubkey": "c93486795ed4db31c9ae0c89a58b3fbac864b8b2570cc4272229159633f043bd",
"created_at": 1716429281,
"kind": 1,
"tags": [
[
"e",
"c382b0299acfb7e5fca4bae6019e372fd0b99f975346176017d38797e2eec4e7",
"",
"root"
],
[
"e",
"cdfab91edf689c1510a6a4573ecf2013245ea3bdc39344d5c1a3518e9da595e0",
"",
"reply"
],
[
"p",
"8240035a9f30abf3fd91387f32e922b6a1240df57fb21d9b267c1c87c65434da"
],
[
"p",
"c93486795ed4db31c9ae0c89a58b3fbac864b8b2570cc4272229159633f043bd"
],
[
"proxy",
"https://mastodon.nervesocket.com/@ThaMunsta/112487909383384952",
"web"
],
[
"proxy",
"https://mastodon.nervesocket.com/users/ThaMunsta/statuses/112487909383384952",
"activitypub"
],
[
"L",
"pink.momostr"
],
[
"l",
"pink.momostr.activitypub:https://mastodon.nervesocket.com/users/ThaMunsta/statuses/112487909383384952",
"pink.momostr"
]
],
"content": "yeah I only keep 30 days media retention. If I want to see an image or video beyond that I'll just go to the remote instance 😂 it's so much data \nToday I cleared out about 200k posts though. Freed up ~5gb of database after doing a VACUUM. Probably not worth the effort but it was a fun experiment",
"sig": "d2cfc8255d6ab87724a2d27c887ef82fbe6a4fee4237a0d62f85b40988283b339413e5889a04a2af17175d328b0f6310e389097ad3ec285790bb5a986600a34c"
}