Yukkuri (npub1j05…w8rl) A topic of pleromer DB optimizations got brought up again, and since you have around the same amount of relays you're subscribed to as me, I wonder how bloated you activity table by their announces is.
select data->>'type', count(data->>'type') as count from activities group by data->>'type' order by count desc;
/
npub1ajw…aj8d
2024-04-26 00:33:44
Author Public Key
npub1ajw6axeack23437kedc8pkwghneenrkh9ljfxxgxumr6t6k4rtvqecaj8dPublished at
2024-04-26 00:33:44Event JSON
{
"id": "69c52d391ab46644546354c00317355186fe23357a789ab31cdf17f28156f659",
"pubkey": "ec9dae9b3dc5951ac7d6cb7070d9c8bcf3998ed72fe4931906e6c7a5ead51ad8",
"created_at": 1714084424,
"kind": 1,
"tags": [
[
"p",
"93e8db96f9dd979cb19accd8a8419a10ff7916057d442b4e1b27c1b505f17541",
"wss://relay.mostr.pub"
],
[
"proxy",
"https://ryona.agency/objects/2ba9333b-0c8d-4374-bc3b-8379d68ec8c4",
"activitypub"
]
],
"content": "nostr:npub1j05dh9hemkteevv6env2ssv6zrlhj9s904zzknsmylqm2p03w4qsxlw8rl A topic of pleromer DB optimizations got brought up again, and since you have around the same amount of relays you're subscribed to as me, I wonder how bloated you activity table by their announces is.\nselect data-\u003e\u003e'type', count(data-\u003e\u003e'type') as count from activities group by data-\u003e\u003e'type' order by count desc;",
"sig": "b4ae6b270d149303eef87d1e5cb5a30e38b673b1175e6c4af76932675948210816aff1ad8709a16d147867ed87ae9c3366d68858622e34c1d646f0fc5a9ed82e"
}