O'Reilly logo

Getting Started with Amazon Redshift by Stefan Bauer

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Database maintenance

There are a few notable items for maintaining the tables within the database. Do run the ANALYZE and VACUUM commands on a regular basis, particularly after data has been loaded or updated. The best practice for both of these maintenance commands is to run them without any options (utilizing the default mode of full). Unless there is a particular reason to only reclaim space, or only re-sort data, there is no tremendous saving that will come from delaying these activities. In addition to the routine maintenance of the tables, ensure you have adequate snapshots of your environment. It is always a good idea to take a snapshot just prior to performing a resize activity as well as immediately after the resize activity has completed. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required