I have a postgresql Master-Slave replication scheme and because of query cancelation due to conflict with wal I need to set the following setting to each replica:
hot_standby_feedback = on
But because this can cause the tables on my master server to have overly large amounts of data that are about to be deleted but not deleted yet, I need to be able to monitor the table size in order to force manually an autovacumm policy on mergency situations (storage starvation or overprice because of storage size).
Therefore, how do I monitor the table size on my database? Also, how I can enforce the
AUTOVACUMM in case of my tables having way too much size.