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:j.a.v....@marin.nl | http://www.marin.nl MARIN news: http://www.marin.nl/web/News/News-items/Maritime-Safety-seminar-September-12-Singapore.htm ________________________________________ From: spacewalk-list-boun...@redhat.com <spacewalk-list-boun...@redhat.com> on behalf of Eric <er...@enrsystems.com> Sent: Thursday, June 22, 2017 17:59 To: spacewalk-list@redhat.com 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 Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list _______________________________________________ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list
