X-Git-Url: http://git.squeep.com/?a=blobdiff_plain;f=docs%2Fadministration%2Fbackup.md;h=be57bf74a66023bc25fb78192b164b0ce10e6358;hb=b59ac37b2c09d5dc80b59bd3a2aea36989bee713;hp=685c45128a26e5ec9ba8c73552c0d28b98c890de;hpb=2f1c61255ff95a1d21a751cb78da3c031ccdd692;p=akkoma

diff --git a/docs/administration/backup.md b/docs/administration/backup.md
index 685c45128..be57bf74a 100644
--- a/docs/administration/backup.md
+++ b/docs/administration/backup.md
@@ -18,6 +18,7 @@
 6. Run `sudo -Hu postgres pg_restore -d <pleroma_db> -v -1 </path/to/backup_location/pleroma.pgdump>`
 7. If you installed a newer Pleroma version, you should run `mix ecto.migrate`[^1]. This task performs database migrations, if there were any.
 8. Restart the Pleroma service.
+9. Run `sudo -Hu postgres vacuumdb --all --analyze-in-stages`. This will quickly generate the statistics so that postgres can properly plan queries.
 
 [^1]: Prefix with `MIX_ENV=prod` to run it using the production config file.