on Nostr: Results of the last rowocaust (deleting remote like/react activities since they're ...
Results of the last rowocaust (deleting remote like/react activities since they're recorded elsewhere): 21% table row count decrease, about 10% total DB size decrease.
Published at
2024-08-17 10:17:47Event JSON
{
"id": "4592d666fff1d3bd60d3b533367109be1e60c677e41980db6b18898820f1e870",
"pubkey": "ec9dae9b3dc5951ac7d6cb7070d9c8bcf3998ed72fe4931906e6c7a5ead51ad8",
"created_at": 1723889867,
"kind": 1,
"tags": [
[
"p",
"ec9dae9b3dc5951ac7d6cb7070d9c8bcf3998ed72fe4931906e6c7a5ead51ad8",
"wss://relay.mostr.pub"
],
[
"e",
"939d9f7d02593741fa1d1bc3ba3a35f43159ae660e65041e6239a51501f7831f",
"wss://relay.mostr.pub",
"reply"
],
[
"proxy",
"https://ryona.agency/objects/a32081f9-a54a-4b4d-b75b-5b8978d33da5",
"activitypub"
]
],
"content": "Results of the last rowocaust (deleting remote like/react activities since they're recorded elsewhere): 21% table row count decrease, about 10% total DB size decrease.",
"sig": "b26715f590528341dfe247ae407d131e8e36007c69f3c67e1d7f0b0cfc821894d530a3098126e26ed5ea1b75ce1a2b7d2ca64790ffee4c4cc0bcc4f515b40254"
}
