Amazon Redshift has enhanced its vacuum operations to support increased concurrency across different tables in data warehouses. This feature reduces maintenance time and improves resource utilization by allowing multiple vacuum operations to run simultaneously.
Vacuum operations maintain optimal query performance by performing two critical functions: sorting table data and reclaiming disk space from deleted rows. Redshift already offers automatic vacuum operations to minimize the need for manual maintenance. Now, these operations run at a higher concurrency automatically managed by Redshift. Further, users can also run multiple manual vacuum operations concurrently on different tables across sessions. This enhancement also extends support to run automatic and manual vacuum operations simultaneously across various vacuum modes. Concurrent vacuum operations reduces the maintenance time and enables better resource utilization of the data warehouse, solving a key operational challenge for database administrators.
This support for concurrent vacuum operations is available in all AWS Regions where Amazon Redshift is available. For more information, please refer to our documentation.
Source:: Amazon AWS