Indeed in ~10 years of administering postgres dbs from 0 - 10TB the only issues that have approached "nightmare" status were from punting vacuum jobs on large/fast growing tables until it got to be too late.

Or even better, turn on autovacuum (buy a roomba)

I like that analogy :)