Conversation

Notices

1.  (mint@ryona.agency)'s status on Wednesday, 03-Apr-2024 04:43:12 JST 
   Watch this MADMAN absolutely DECIMATE his instance's database with ONE WEIRD TRICK!
   Снимок экрана_20240402_224213.p…
   • :blank: (i@declin.eu)'s status on Wednesday, 03-Apr-2024 04:53:08 JST :blank:

     in reply to
     @mint it's VACUUM time
      likes this.
   •  (mint@ryona.agency)'s status on Wednesday, 03-Apr-2024 07:30:12 JST 

     in reply to
     The query has been running for 10894.457866 seconds and still haven't finished. Right now I'm just waiting for it to finish so that I start the repacking process for the table and go to sleep.
     † top dog :pedomustdie: likes this.
   •  (mint@ryona.agency)'s status on Wednesday, 03-Apr-2024 08:47:08 JST 

     in reply to
     Using LIKE was likely a bad idea, better do something like `data->>'actor' in (select ap_id from users where id in (select following_id from users where follower_id = (select id from users where nickname = 'relay')))`. Though that won't handle relays that I'm not subscribed to anymore.
   •  (mint@ryona.agency)'s status on Wednesday, 03-Apr-2024 09:00:10 JST 

     in reply to
     Hope I didn't fuck up for not accounting for automatic reindexing after each deleted row or something.
   •  (mint@ryona.agency)'s status on Wednesday, 03-Apr-2024 09:02:28 JST 

     in reply to
     Think that's a good sign.
     Снимок экрана_20240403_030149.p…
   •  (mint@ryona.agency)'s status on Wednesday, 03-Apr-2024 09:03:06 JST 

     in reply to
     No, it's just my backup cron job kicking in.
   • :blank: (i@declin.eu)'s status on Wednesday, 03-Apr-2024 09:05:25 JST :blank:

     in reply to
     @mint have to do mine in one day/hour increments to avoid this
      likes this.
   •  (mint@ryona.agency)'s status on Wednesday, 03-Apr-2024 16:13:02 JST 

     in reply to
     42340.205402, still going.
   •  (mint@ryona.agency)'s status on Wednesday, 03-Apr-2024 20:55:43 JST 

     in reply to
     59252.432806. I will try turning instance off, disabling triggers for activities and then deleting them.