npub1pv24lsy7l5sjht3e4hg7w79lp4dgj3cxtfw3rvp6uwl46lfjywkqna4kk8 (npub1pv2…4kk8) npub1y740vxjetspkm3kg80mzg9rzzurnva4f90jnn8ul3yxzrky8h66qugzx0q (npub1y74…zx0q) that could be the issue but also not...
also pg_repack https://reorg.github.io/pg_repack/ https://github.com/reorg/pg_repack can help rebuilding the tables & indexes while beeing live. So you can get rid of the bloat & rebuild all indexes so you will get a neat & fresh db...
there is one small issue i have with it, i can explain that if you are interested
:blobcatverified2: /
npub1xp…qamfw
2023-12-11 18:18:54
in reply to nevent1q…uya5
Author Public Key
npub1xp9u5xtw5sx7s8z7jnjc3m44268vxm6254xdquaaup0cjwwmqezs8qamfwPublished at
2023-12-11 18:18:54Event JSON
{
"id": "fbdee4eeda3f071b9e06058e6a536de1f60aa380e3df18925b1367c2208c8cf0",
"pubkey": "304bca196ea40de81c5e94e588eeb5568ec36f4aa54cd073bde05f8939db0645",
"created_at": 1702318734,
"kind": 1,
"tags": [
[
"p",
"0b155fc09efd212bae39add1e778bf0d5a8947065a5d11b03ae3bf5d7d3223ac",
"wss://relay.mostr.pub"
],
[
"p",
"27aaf61a595c036dc6c83bf624146217073676a92be5399f9f890c21d887beb4",
"wss://relay.mostr.pub"
],
[
"p",
"304bca196ea40de81c5e94e588eeb5568ec36f4aa54cd073bde05f8939db0645",
"wss://relay.mostr.pub"
],
[
"p",
"c5cd4f260e9ac3e29c53a419d9306d82edc4ba0527707aa893fc02a6bda33119",
"wss://relay.mostr.pub"
],
[
"p",
"72ea818422f8d09ae5726a86fa9ea4aebed01f8fbe204a8f3515d2f78d9749a2",
"wss://relay.mostr.pub"
],
[
"e",
"c5ca9d38fa9fbb1102927147745aae937ae4de64ac685322e045bfb9d9c9db31",
"wss://relay.mostr.pub",
"reply"
],
[
"proxy",
"https://blob.cat/objects/65fadc38-8698-4a76-972f-9aa4a5911480",
"activitypub"
]
],
"content": "nostr:npub1pv24lsy7l5sjht3e4hg7w79lp4dgj3cxtfw3rvp6uwl46lfjywkqna4kk8 nostr:npub1y740vxjetspkm3kg80mzg9rzzurnva4f90jnn8ul3yxzrky8h66qugzx0q that could be the issue but also not... \nalso pg_repack https://reorg.github.io/pg_repack/ https://github.com/reorg/pg_repack can help rebuilding the tables \u0026 indexes while beeing live. So you can get rid of the bloat \u0026 rebuild all indexes so you will get a neat \u0026 fresh db...\nthere is one small issue i have with it, i can explain that if you are interested",
"sig": "1a1e73f284a0651741bce165db961a983aa5064fd240217592ab8ebeff24ec9496f886ec6f9c65648a56a3388dd9dd76fd7bef78d277f5326bf7a9b50d192e89"
}