Conversation

Notices

1. Embed this notice
   aetios (aetios@ak.kawen.space)'s status on Monday, 03-Feb-2025 21:50:48 JST aetios
   is there some general health check I can do on postgres...?
   • Puniko ? likes this.
   • Embed this notice
     Puniko ? (puniko@mk.absturztau.be)'s status on Monday, 03-Feb-2025 21:51:16 JST Puniko ?

     in reply to

     @aetios@ak.kawen.space what are you looking for specifically?

   • Embed this notice
     Puniko ? (puniko@mk.absturztau.be)'s status on Monday, 03-Feb-2025 21:54:26 JST Puniko ?

     in reply to

     @aetios@ak.kawen.space auauaua. there is a thingy thing were you can log slow queries in psql. should be documented somewhere in the psql docs. with that at least, you would know what to look for.
     
     did you pg_repack or full vacuum? or even reindex?

   • Embed this notice
     aetios (aetios@ak.kawen.space)'s status on Monday, 03-Feb-2025 21:54:27 JST aetios

     in reply to

     • Puniko ?
     @puniko
   • Embed this notice
     aetios (aetios@ak.kawen.space)'s status on Monday, 03-Feb-2025 21:54:28 JST aetios

     in reply to

     • Puniko ?
     @puniko so as you can see i am having a LOT of slow queries bogging down my database and this did not happen before I updated to postgres 17 this weekend, I'm wondering why its so slow
   • Embed this notice
     Puniko ? (puniko@mk.absturztau.be)'s status on Monday, 03-Feb-2025 21:56:10 JST Puniko ?

     in reply to

     @aetios@ak.kawen.space maybe run a full vacuum on it, just in case. and then check your psql config using pgtune, that usually can help to get the most out of the psql cluster

   • Embed this notice
     aetios (aetios@ak.kawen.space)'s status on Monday, 03-Feb-2025 21:56:11 JST aetios

     in reply to

     • Puniko ?
     @puniko i did nothing, i dont know how to take care of a database :D
   • Embed this notice
     Puniko ? (puniko@mk.absturztau.be)'s status on Monday, 03-Feb-2025 21:58:37 JST Puniko ?

     in reply to

     @aetios@ak.kawen.space the p in psql stands for pain :blobcatgooglyfingerguns:
     
     at least its better than mariadb in many ways

   • Embed this notice
     aetios (aetios@ak.kawen.space)'s status on Monday, 03-Feb-2025 21:58:38 JST aetios

     in reply to

     • Puniko ?
     @puniko thank you. I'm sure it can be salvaged, but it's a pain! haha