-
|
I believe I am experiencing the same upgrade problem as others have experienced (such as #7727 and #7878). The solution seems to be to run the "VACUUM FULL assets;" command on the database. Can someone please explain how to do this like I am 5 years old? I opened a terminal (in Portainer) for the postgres container. However, when I typed VACUUM FULL assets; I got an error saying 'command not found'. Any help would be massively appreciated! |
Beta Was this translation helpful? Give feedback.
Replies: 1 comment
-
|
Found the answer in #7313 : Command line at the immich_postgres container (for me, i used synology container manager -> action -> Open terminal -> Create ; SSH to the NAS also works) |
Beta Was this translation helpful? Give feedback.
Found the answer in #7313 :
Command line at the immich_postgres container (for me, i used synology container manager -> action -> Open terminal -> Create ; SSH to the NAS also works)
Run "psql -U postgres". Command line should then show psql at the start
Run "\c immich" to point to the immich database
run "VACUUM FULL smart_search;", took 10 seconds for my 100gb photos/videos.
Search is immediately restored without requiring a smart search rerun.