you on Nostr: Alex nostr_tags started growing quite quickly, currently taking up 2.4x more space ...
Alex (npub1q3s…d26p) nostr_tags started growing quite quickly, currently taking up 2.4x more space than the events themselves, with the three created_at index variations taking up 3/4's of that
a task to clear martian (non local/follow) events/tags created later than N days would be appreciated
Published at
2024-08-04 11:47:02Event JSON
{
"id": "69bda3871a30869eabe7fbd588961bca5e41743e9017ecc54e04c0e1e47411e6",
"pubkey": "145a66a34db2b5ac7874ae75476296818e66300316e6b123d9f60c343df8f612",
"created_at": 1722772022,
"kind": 1,
"tags": [
[
"imeta",
"url https://media.256.lt/e73bb02a559f47430cc60c882aebfea0d26efd25c3a975f4eb338b1053e6dd78.png",
"m image/png",
"x e73bb02a559f47430cc60c882aebfea0d26efd25c3a975f4eb338b1053e6dd78",
"size 33144"
],
[
"p",
"0461fcbecc4c3374439932d6b8f11269ccdb7cc973ad7a50ae362db135a474dd"
]
],
"content": "nostr:npub1q3sle0kvfsehgsuexttt3ugjd8xdklxfwwkh559wxckmzddywnws6cd26p nostr_tags started growing quite quickly, currently taking up 2.4x more space than the events themselves, with the three created_at index variations taking up 3/4's of that\n\na task to clear martian (non local/follow) events/tags created later than N days would be appreciated \n\nhttps://media.256.lt/e73bb02a559f47430cc60c882aebfea0d26efd25c3a975f4eb338b1053e6dd78.png",
"sig": "f7f5f0e32ace7a37a9591ef7487abf9f1636c8ee1dab4cab686987397684901d45d3a287860e934df0f248ffcc8a849cc5610558db391fa217adb65db9b68d47"
}