shivyadav
New Contributor II

Once predictive optimization is enabled and the table is in use, VACUUM will be automatically triggered 7 days later.

But if a table with predictive optimization enabled has no active usage, the optimization process does not detect the table or its previously deleted data.