I show a tip of autovacuum management.
As frequently mentioned, the table bloat problem is one of the most annoying things in managing PostgreSQL. Several things can cause that problem, and Autovacuum is one of them.
I’ve just released pg_plan_inspector that is a framework to monitor and improve the performance of PostgreSQL using Machine Learning methods.
One movie is worth a thousand words. Watch this movie.
I made a PostgreSQL’s module called shutdown_db using weekend time.
This module emulates the Oracle’s shutdown commands by controlling access for each DB.