Post Al2mv2ikn8SfbzWvFA by mint@plagu.ee
 (DIR) More posts by mint@plagu.ee
 (DIR) Post #Al2mv2ikn8SfbzWvFA by mint@plagu.ee
       2024-08-17T02:26:57.850101Z
       
       1 likes, 0 repeats
       
       So much faster than agency despite running in a VM with a third of resources and still being subscribed to a shitton of relays. Guess not having any other users makes the difference.
       
 (DIR) Post #Al2nCehmosXELDTZLM by mint@plagu.ee
       2024-08-17T02:30:08.796909Z
       
       0 likes, 0 repeats
       
       The DB is 38 gigs on disk compared to agency's 63. Don't know what other differences could be there, likely can't be postgres since accela (from local mirror) loads pretty much instantly as well.
       
 (DIR) Post #Al2ntnNOSMf1gbVYRM by mint@plagu.ee
       2024-08-17T02:37:56.602780Z
       
       0 likes, 0 repeats
       
       Could maybe strip 5 million likes/reacts like I did here before without breaking anything, but that would reclaim a couple gigs of space at best.Screenshot_20240817_053659.png
       
 (DIR) Post #Al2oUEd6beUGdVEV3g by mint@plagu.ee
       2024-08-17T02:44:31.606439Z
       
       0 likes, 0 repeats
       
       That would still account for 21% of total activites. Fuck it, we'll do it live.
       
 (DIR) Post #Al2rCSfBzTTooKQRMG by mint@plagu.ee
       2024-08-17T03:14:50.277364Z
       
       0 likes, 0 repeats
       
       Now I am become death, destroyer of rows.Screenshot_20240817_061624.png
       
 (DIR) Post #Al2rMMAF0dY9Y8fOMK by mint@plagu.ee
       2024-08-17T03:16:43.182014Z
       
       0 likes, 0 repeats
       
       (I think local likes/reacts should be excluded in case they couldn't be retracted.)Either way, time for repack, only on one table to not waste too much time.
       
 (DIR) Post #Al2uWaFXnIcFzeiPgm by goatmeal@shitposter.world
       2024-08-17T03:54:19.202141Z
       
       1 likes, 1 repeats
       
       @mint blue elephant balls
       
 (DIR) Post #Al3RXHt6qU3Lp2AIIi by mint@plagu.ee
       2024-08-17T10:02:04.582061Z
       
       0 likes, 0 repeats
       
       Went to sleep in meanwhile, after repacking DB size is at 57 gigs. Not too shabby since now it's even smaller than salon's.