Untitled attachment

Notices where this attachment appears

1. Embed this notice
   Yukkuri (iamtakingiteasy@eientei.org)'s status on Tuesday, 30-Sep-2025 20:35:51 JST Yukkuri

   in reply to
   @phnt @i @w0rm @prettygood Here; also pushed commit inverting known activity types to the exclude_type filter, so an index would be used during post deletes.
   
   https://eientei.org/objects/fafbe44b-51a9-469e-a9cc-95a4d877693c
2. Embed this notice
   feld (feld@friedcheese.us)'s status on Friday, 18-Apr-2025 08:50:51 JST feld
   @lain did you see this?
   
   RT: https://eientei.org/objects/fafbe44b-51a9-469e-a9cc-95a4d877693c
3. Embed this notice
   Yukkuri (iamtakingiteasy@eientei.org)'s status on Friday, 18-Apr-2025 00:07:38 JST Yukkuri

   in reply to
   @mint @dsm https://eientei.org/objects/fafbe44b-51a9-469e-a9cc-95a4d877693c -- here is a writeup and here are pleroma patches and migrations: https://gitlab.eientei.org/eientei/pleroma/-/tree/upstream-flake
   
   Since it needs to migrate object ids to time-ordered snowflakes and rearrange some of the denormalized fields to properly partition the tables anyway, it also changes a bunch of queries to take advantage of new layout, as many joins became easier. Migration includes both up and down, so it is possible to rollback, but migration back from partitioned layout wasn't very well tested, especially after new objects were inserted. Eientei runs on this for a couple of months now, so it is more or less reasonable in terms of completeness. But to be something more than just 15% of overhead, it requires understanding of what you're doing. Then sure, moving all older rows to a partition on cheaper or even a networked storage is possible.