VACUUM operations on existing table after enabling predictive optimization
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-23-2025 11:56 PM
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.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-24-2025 12:31 AM
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.
