Reclaiming Space from Deletes and Updates Using Vacuum

Redshift and other MPP databases perform soft deletes during explicit and implicit delete operations (i.e. updates are an insert and delete). These soft-deleted records take up space and can impact query performance. Therefore, there is a need to reclaim this space through a command called vacuum.  
 
The Aginity Workbench for Redshift allows you to quickly see if there is a need to perform a reclaim using the vacuum command through either the Object > Database > Show Table Sizes command or the Object > Database > Database Maintenance command.
 
The Database Maintenance command allows you to run a reclaim process against all tables that need it. You can also use the Object > Table > Advanced > Vacuum command to choose what tables you want to reclaim data on.

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk