Pleroma
Pleroma
Database DB psql
check the postgres HOWTO for understanding sizes and problems.
most commands come from the official pleroma docs
execute bash as pleroma user
su pleroma -s $SHELL -lc "/PATH/TO/PLEROMA/bin/pleroma_ctl <COMMAND> <OPTIONS>"Prune old remote posts from the database
su pleroma -s $SHELL -lc "/var/www/pleroma/live/bin/pleroma_ctl database prune_objects --vacuum"Vacuum db
Analyze first
su pleroma -s $SHELL -lc "/var/www/pleroma/live/bin/pleroma_ctl database vacuum analyze"Run a vacuum after
su pleroma -s $SHELL -lc "/var/www/pleroma/live/bin/pleroma_ctl database vacuum full"