Thread of 2 posts
jump to replies
Hey gotosocial admins and devs!
My #gotosocial instance got interrupted while duing database migrations and now struggles with slow queries probably due to missing indices. Is there a way to check the db for what is missing or to somehow get it into a working state again?
Alternatively would restoring the db from a dump help?
Please boost.
Thanks!
I have successfully run an ANALYZE run on the db and now it seems to work as fast as before. Thanks for your hints and answers!
1 reply
back to top
@ckeen Restoring the DB will most likely cause the upgrade to run again, and hopefully fix the issue. Of course you will loose all data that was created in the DB since the dump.