As seen in this answer by setting postgresql's
hot_standby_feedback on it may cause having bloated table on long running queries. Therefore, in case that size goes out of control (my database consumes way too much space because of dead rows) to be able to handle it.
Therefore, I thought to enforce a
VACCUMM action in this situation to delete stale and unused rows in case that storage goes out of controll as immediate action.
But how I can VACUUM all the tables of my database manually? Also, how I can make a dedicated user that is able only to
VACUUM in order to create custom scripts that I can run in these situations?