I run the following line from the psql user cron every night to clean up the database
psql -d jabberd2 -c "VACUUM FULL ANALYZE VERBOSE" >> /var/log/rhn/spacewalk-database-maintenance.txt 2>&1 This seems to work for me, even the check_mk postgresql check doesn't complain about table bloat any more. -- Jan-Albert Jan-Albert van Ree | Linux System Administrator | MARIN Support Group MARIN | T +31 317 49 35 48 | mailto:[email protected] | http://www.marin.nl MARIN news: http://www.marin.nl/web/News/News-items/Maritime-Safety-seminar-September-12-Singapore.htm ________________________________________ From: [email protected] <[email protected]> on behalf of Eric <[email protected]> Sent: Thursday, June 22, 2017 17:59 To: [email protected] Subject: [Spacewalk-list] Maintaining JabberD/PostgreSQL So now that I've got Jabberd switched over to Postgres following AVI's blog, does anyone have any specific tips on how to prune the old entries? I'd like to be able to clean it up fairly regularly, as it does grow pretty fast. Thanks, Eric _______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list _______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
