Conversation

Notices

1. 💀💀💀 :0080: c̷̨̢̛̲̼̞̞͓̹͚̗̼͓͚͖͒̔̓̃̈̋̂́̏̆̐̐̈́̉͘͜ȑ̴̫͔͂̌̔̆̓͛͗́͐̍̃́̆ÿ̷̤̺̳̖͖͚͈́̄́͌͒͂͊͗̄̔̚p̶̢̧͇̞̯͍͇̤̖͖̙̫̪͋̏̃̃͗̎͜͝t̶͖̉̽̐̇i̴̭̜̼͖̬̽̀͆̃̓̂̚͝ͅc̸̡͙̪͎̫͚̫̘̱͚͔̫̣̣̒̃̋͜͝ 💀💀💀 :verified: (newt@stereophonic.space)'s status on Sunday, 12-Feb-2023 05:10:10 JST 💀💀💀 :0080: c̷̨̢̛̲̼̞̞͓̹͚̗̼͓͚͖͒̔̓̃̈̋̂́̏̆̐̐̈́̉͘͜ȑ̴̫͔͂̌̔̆̓͛͗́͐̍̃́̆ÿ̷̤̺̳̖͖͚͈́̄́͌͒͂͊͗̄̔̚p̶̢̧͇̞̯͍͇̤̖͖̙̫̪͋̏̃̃͗̎͜͝t̶͖̉̽̐̇i̴̭̜̼͖̬̽̀͆̃̓̂̚͝ͅc̸̡͙̪͎̫͚̫̘̱͚͔̫̣̣̒̃̋͜͝ 💀💀💀 :verified:
   My plan right now is to fetch the newly made copy of our database home and try to reindex it. If it takes under a day, I'm willing to do the same on the main server, taking it offline.
   • 💀💀💀 :0080: c̷̨̢̛̲̼̞̞͓̹͚̗̼͓͚͖͒̔̓̃̈̋̂́̏̆̐̐̈́̉͘͜ȑ̴̫͔͂̌̔̆̓͛͗́͐̍̃́̆ÿ̷̤̺̳̖͖͚͈́̄́͌͒͂͊͗̄̔̚p̶̢̧͇̞̯͍͇̤̖͖̙̫̪͋̏̃̃͗̎͜͝t̶͖̉̽̐̇i̴̭̜̼͖̬̽̀͆̃̓̂̚͝ͅc̸̡͙̪͎̫͚̫̘̱͚͔̫̣̣̒̃̋͜͝ 💀💀💀 :verified: (newt@stereophonic.space)'s status on Sunday, 12-Feb-2023 05:10:01 JST 💀💀💀 :0080: c̷̨̢̛̲̼̞̞͓̹͚̗̼͓͚͖͒̔̓̃̈̋̂́̏̆̐̐̈́̉͘͜ȑ̴̫͔͂̌̔̆̓͛͗́͐̍̃́̆ÿ̷̤̺̳̖͖͚͈́̄́͌͒͂͊͗̄̔̚p̶̢̧͇̞̯͍͇̤̖͖̙̫̪͋̏̃̃͗̎͜͝t̶͖̉̽̐̇i̴̭̜̼͖̬̽̀͆̃̓̂̚͝ͅc̸̡͙̪͎̫͚̫̘̱͚͔̫̣̣̒̃̋͜͝ 💀💀💀 :verified:

     in reply to

     • karolat
     @karolat you also changed database settings. I actually had to fix after you, because you decreased the number of allowed connections in postgres but didn't do the same in pleroma settings.
   • karolat (karolat@stereophonic.space)'s status on Sunday, 12-Feb-2023 05:10:02 JST karolat

     in reply to
     @newt what’s strange is that after I did the analyze we constantly get 500s when viewing profiles. I don’t thin this was happening before, or at least I didn’t notice it
   • 💀💀💀 :0080: c̷̨̢̛̲̼̞̞͓̹͚̗̼͓͚͖͒̔̓̃̈̋̂́̏̆̐̐̈́̉͘͜ȑ̴̫͔͂̌̔̆̓͛͗́͐̍̃́̆ÿ̷̤̺̳̖͖͚͈́̄́͌͒͂͊͗̄̔̚p̶̢̧͇̞̯͍͇̤̖͖̙̫̪͋̏̃̃͗̎͜͝t̶͖̉̽̐̇i̴̭̜̼͖̬̽̀͆̃̓̂̚͝ͅc̸̡͙̪͎̫͚̫̘̱͚͔̫̣̣̒̃̋͜͝ 💀💀💀 :verified: (newt@stereophonic.space)'s status on Sunday, 12-Feb-2023 05:10:04 JST 💀💀💀 :0080: c̷̨̢̛̲̼̞̞͓̹͚̗̼͓͚͖͒̔̓̃̈̋̂́̏̆̐̐̈́̉͘͜ȑ̴̫͔͂̌̔̆̓͛͗́͐̍̃́̆ÿ̷̤̺̳̖͖͚͈́̄́͌͒͂͊͗̄̔̚p̶̢̧͇̞̯͍͇̤̖͖̙̫̪͋̏̃̃͗̎͜͝t̶͖̉̽̐̇i̴̭̜̼͖̬̽̀͆̃̓̂̚͝ͅc̸̡͙̪͎̫͚̫̘̱͚͔̫̣̣̒̃̋͜͝ 💀💀💀 :verified:

     in reply to

     • karolat
     @karolat nope. Now you need an index for an index lol.
   • karolat (karolat@stereophonic.space)'s status on Sunday, 12-Feb-2023 05:10:05 JST karolat

     in reply to
     @newt with all those indexes you think the queries would be pretty fast :blobthinkglare:
   • 💀💀💀 :0080: c̷̨̢̛̲̼̞̞͓̹͚̗̼͓͚͖͒̔̓̃̈̋̂́̏̆̐̐̈́̉͘͜ȑ̴̫͔͂̌̔̆̓͛͗́͐̍̃́̆ÿ̷̤̺̳̖͖͚͈́̄́͌͒͂͊͗̄̔̚p̶̢̧͇̞̯͍͇̤̖͖̙̫̪͋̏̃̃͗̎͜͝t̶͖̉̽̐̇i̴̭̜̼͖̬̽̀͆̃̓̂̚͝ͅc̸̡͙̪͎̫͚̫̘̱͚͔̫̣̣̒̃̋͜͝ 💀💀💀 :verified: (newt@stereophonic.space)'s status on Sunday, 12-Feb-2023 05:10:06 JST 💀💀💀 :0080: c̷̨̢̛̲̼̞̞͓̹͚̗̼͓͚͖͒̔̓̃̈̋̂́̏̆̐̐̈́̉͘͜ȑ̴̫͔͂̌̔̆̓͛͗́͐̍̃́̆ÿ̷̤̺̳̖͖͚͈́̄́͌͒͂͊͗̄̔̚p̶̢̧͇̞̯͍͇̤̖͖̙̫̪͋̏̃̃͗̎͜͝t̶͖̉̽̐̇i̴̭̜̼͖̬̽̀͆̃̓̂̚͝ͅc̸̡͙̪͎̫͚̫̘̱͚͔̫̣̣̒̃̋͜͝ 💀💀💀 :verified:

     in reply to

     • karolat
     @karolat indexes for it are bigger than the table itself. If reindexing solves it, then we're all good and can repack the rest.
   • karolat (karolat@stereophonic.space)'s status on Sunday, 12-Feb-2023 05:10:07 JST karolat

     in reply to
     @newt maybe we can just take it offline to vacuum full the activities, and then unpack the rest online :blobcatcomfthink:
   • 💀💀💀 :0080: c̷̨̢̛̲̼̞̞͓̹͚̗̼͓͚͖͒̔̓̃̈̋̂́̏̆̐̐̈́̉͘͜ȑ̴̫͔͂̌̔̆̓͛͗́͐̍̃́̆ÿ̷̤̺̳̖͖͚͈́̄́͌͒͂͊͗̄̔̚p̶̢̧͇̞̯͍͇̤̖͖̙̫̪͋̏̃̃͗̎͜͝t̶͖̉̽̐̇i̴̭̜̼͖̬̽̀͆̃̓̂̚͝ͅc̸̡͙̪͎̫͚̫̘̱͚͔̫̣̣̒̃̋͜͝ 💀💀💀 :verified: (newt@stereophonic.space)'s status on Sunday, 12-Feb-2023 05:10:09 JST 💀💀💀 :0080: c̷̨̢̛̲̼̞̞͓̹͚̗̼͓͚͖͒̔̓̃̈̋̂́̏̆̐̐̈́̉͘͜ȑ̴̫͔͂̌̔̆̓͛͗́͐̍̃́̆ÿ̷̤̺̳̖͖͚͈́̄́͌͒͂͊͗̄̔̚p̶̢̧͇̞̯͍͇̤̖͖̙̫̪͋̏̃̃͗̎͜͝t̶͖̉̽̐̇i̴̭̜̼͖̬̽̀͆̃̓̂̚͝ͅc̸̡͙̪͎̫͚̫̘̱͚͔̫̣̣̒̃̋͜͝ 💀💀💀 :verified:

     in reply to

     • karolat
     cc @karolat
   • karolat (karolat@stereophonic.space)'s status on Sunday, 12-Feb-2023 05:11:08 JST karolat

     in reply to
     @newt I did, I experimented with 10 and 20 and settled on 20 for pleroma. That’s the max pool, right?