Conversation

Notices

1. Embed this notice
   SolSoCoG (solsocog@ieji.de)'s status on Tuesday, 23-Jan-2024 08:01:21 JST SolSoCoG

   I was like "huh thats odd, on the second, identical server, postgres only uses like 5% of the cpu, how?" and then this showed up. Yep the whole Ryzen 7950x strangled by postgres. By just postgres, nothing else. Nice.

   • Embed this notice
     SolSoCoG (solsocog@ieji.de)'s status on Tuesday, 23-Jan-2024 08:07:44 JST SolSoCoG

     in reply to

     ok the huge 5h backlog was finished within a couple of minutes though, now it calmed down to using around 6 cores.

   • Embed this notice
     SolSoCoG (solsocog@ieji.de)'s status on Tuesday, 23-Jan-2024 08:32:15 JST SolSoCoG

     in reply to

     • Samuel

     @samuel I shoved /var/lib/postgresql/16/main/ from Server A to Server B, both are 95% identical (except for the mainboard), no issues. a pgdump would have taken like 50x the time :tom_scott:

   • Embed this notice
     Samuel (samuel@social.meenzen.net)'s status on Tuesday, 23-Jan-2024 08:32:16 JST Samuel

     in reply to

     @SolSoCoG my 600GiB db on some spinning rust has been migrating from postgres v15 to v16 for the last 8 hours now 😅

   • Embed this notice
     SolSoCoG (solsocog@ieji.de)'s status on Tuesday, 23-Jan-2024 08:32:50 JST SolSoCoG

     in reply to

     • Samuel

     @samuel but well right, version differences is something else, isn't as easy 😂

   • Embed this notice
     SolSoCoG (solsocog@ieji.de)'s status on Tuesday, 23-Jan-2024 08:44:29 JST SolSoCoG

     in reply to

     • Samuel

     @samuel oh god that sounds very very uncomfortable, wish you the best of luck there :schmusekadser: . Got a non python matrix server you recommend? I consider setting a private matrix up again.

   • Embed this notice
     Samuel (samuel@social.meenzen.net)'s status on Tuesday, 23-Jan-2024 08:44:30 JST Samuel

     in reply to

     @SolSoCoG That db shouldn't be this huge anyway, it just grew like crazy because of a bug in the Synapse Matrix server. I ran out of storage so I had to migrate from SSD to this hot garbage unoptimized zstd compressed ZFS volume... It's painful.

     Never use Python based server software in prod. This is what happens.