This issue is particularly critical during database migrations or version upgrades, where a full data reload is often necessary. Each time a major PostgreSQL upgrade occurs, users must reimport large datasets, leading to the same problem of vacuum storms post import.
What major upgrade process are you doing that uses INSERT?