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 ...

Get Getting Started with Amazon Redshift now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.