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

Table maintenance

I know I started off by saying how much maintenance you no longer have to do, and I am not really backing off from that. However, there is still data maintenance that needs to be considered. Since there are no indexes to manage, there really is only the space within the table you need to concern yourself with. The two primary commands are ANALYZE and VACUUM. You can ask my wife; I don't like to vacuum at home, and I don't really like to vacuum my databases, but just like at home, it really is a necessary task. For those of you familiar with Postgres, this is the same command with a different Redshift-specific implementation. Although important, it is not necessarily a lightweight operation, and you should take some consideration ...

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