topic VACUUM operations on existing table after enabling predictive optimization in Data Engineering

VACUUM operations on existing table after enabling predictive optimization

ShivangiB1 — Tue, 24 Jun 2025 06:56:13 GMT

Hey Team,

I have a table with files deleted 7 days before, but predictive optimization was not enabled.Today have enabled predictive optimization, how much time will it take to perform vaccum on existing data.

Re: VACUUM operations on existing table after enabling predictive optimization

shivyadav — Tue, 24 Jun 2025 07:31:30 GMT

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.