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.

** Aginity, Inc.’s Provision of Scripts and Similar Materials at Help Desk Center. For the convenience of Aginity Amp™ clients, we provide code snippets, scripts and similar materials at this Help Desk Center. Such materials are reference materials provided for illustration purposes only. These are intended to serve as an example for self-service clients and are generally geared to respond to common questions asked by similar clients. Such materials constitute Aginity’s intellectual property. Aginity Amp clients and their authorized users are permitted to use these materials in connection with their software license and/or subscription of Aginity Amp. Nothing herein shall limit Aginity’s right to use, develop, enhance, modify or market any of these materials as part of its business. These materials are not formally supported by Aginity or its affiliates. Usage of these materials does not guarantee any specific results, uptime, performance or error-free operation. Aginity disclaims all warranties of any kind, whether express, implied, statutory or otherwise, including any implied warranty of merchantability or fitness for a particular purpose.

Powered by Zendesk