- Newest
- Most votes
- Most comments
Hello,
To answer your question about why Amazon Redshift performs a vacuum delete, a vacuum delete operation may be performed to clean up tables after a load or a series of incremental updates. When you perform a delete, the rows are marked for deletion, but not removed. Amazon Redshift automatically runs a VACUUM DELETE operation in the background based on the number of deleted rows in database tables. Redshift schedules the VACUUM DELETE to run during periods of reduced load and pauses the operation during periods of high load.
Please see this documentation on Vacuuming tables for more information.
For a deeper dive on why this would be happening with the underlying table one of your Kinesis Streams Materialized Views and not the others, we require details that are non-public information. Please open a support case with AWS using the following link.
Relevant content
- Accepted Answerasked 9 months ago
- asked 5 months ago
- Accepted Answerasked a year ago
- AWS OFFICIALUpdated 2 months ago
- AWS OFFICIALUpdated 7 months ago
- AWS OFFICIALUpdated 2 years ago