Conversation

Notices

1. Embed this notice
   Eugen Rochko (gargron@mastodon.social)'s status on Friday, 23-Feb-2024 05:43:35 JST Eugen Rochko

   in reply to

   • かき@GNUsocialJP
   • Ellie 🐍☃️ :blobsnowedin:​

   @noelle If it operates normally otherwise (i.e. no data loss, no missing indices) it may be that your database simply needs an `ANALYZE`.

   • Embed this notice
     Ellie 🐍☃️ :blobsnowedin:​ (noelle@chat.noelle.codes)'s status on Friday, 23-Feb-2024 05:43:37 JST Ellie 🐍☃️ :blobsnowedin:​

     #mastoadmin This happened to me with a live server, and I've verified it experimentally, and so I pass it on to you:

     If you're upgrading to Mastodon 4.3.x, it no longer supports Postgres 9, and it's tempting to export your PSQL 9 database and import it directly into a more modern version like 12 or 16; this is supposed to auto-convert it to the new format.

     Please don't. Step upward by one version at a time. The direct upgrade trashes Mastodon's performance somehow.