Monday, 24 December 2018

Amazon Redshift Executes VACUUM DELETE automatically

Now Amazon Redshift automatically executes the VACUUM DELETE task to retrieve disk space filled by rows that were signed for removal by last UPDATE and DELETE tasks. It also defragments the tables to make vacant used space and boost performance for your workloads. VACUUM DELETE is arranged to execute related to query load and the number of deleted rows in tables. For example, VACUUM DELETE executes only sporadically while times of high load to minimize the effect on users and queries. Automatic VACUUM DELETE halts when the incoming query load is high, then restarts later. Frequently planned VACUUM DELETE jobs don't require to be altered because Amazon Redshift omits tables that don't require to be vacuumed. Besides, now every vacuum tasks execute only on a portion of a table at a given time instead of executing on the full table. This extremely minimizes the amount of resources like memory, CPU, and disk I/O needed to vacuum. Now, this VACUUM DELETE is obtainable with the release version 1.0.5290 or higher in each AWS commercial regions. Go through AWS Region Table for Amazon Redshift availability. To get more information, refer VACUUM in the Amazon Redshift Database Developer Guide.

No comments:

Post a Comment

AWS CodePipeline Can Be Used To Deploy Files To Amazon S3

AWS CodePipeline is a completely managed continuous delivery service which assists you automate your release pipelines for rapid and ...