The Benefits of Auto Vacuuming for Query Performance

There are direct and indirect benefits for query performance if you use partitioning. indexes are smaller and faster good but we all know that B3 height grows very slowly so you need to have like jumping from 1 million rows to 1 billion rows it's not just a few hops in terms of industry drivers. I usually recommend up to 30 percent of vCPUs to set number of workers max for number of workers for auto vacuum. If you're planning to use partitioning you definitely need to reconsider your auto vacuum tuning settings and have more workers.