There is no problem with vaccum, i used to do it periodically...apart from vaccum i am asking things like table bloat, index bloat, duplicate index removal, unused index removal, cache hit ratio for table, cache hit ratio for index, .......what else?
Also, i saw cache hit ratio is only 2% for one big table and all other tables are around 9%. Is that a problem?
As a preliminary and often but good enough test, I recommend VACUUM FREEZE VERBOSE ... In 95% of cases such simple check will satisfy your needs . Of course amcheck tool is much better but it is an extension.
