I currently have a table that is updated daily (easily 20%+ rows are updated, all floats/integers) and the vacuum is kicking off and running for more than 18 hours. There are 19 million rows total.
Does this seem indicative of a problem? It slows the entire database down and it's running on a pretty powerful machine (32 cores, 128 GB RAM, SSD).
Any suggestions on how to correct/fix/debug further?
All vacuum settings are default.