Managing column compression
Amazon Redshift columnar architecture stores data column by column on the disk. Analytical queries select a subset of the column and perform aggregation on millions to billions of records. The columnar architecture reduces the I/O by selecting a subset of the columns and hence improves query performance. When data is ingested into an Amazon Redshift table, it provides three to four times compression. This further reduces the storage footprint, which in turn reduces I/O and hence improves query performance. Reducing the storage footprint also saves you costs. Amazon Redshift Advisor provides recommendations for compressing uncompressed tables.
In this recipe, you will see how Amazon Redshift automatically applies compression on new and existing tables. You will also see how column-level compression can be modified for existing columns.
Getting ready
To complete this recipe, you will need:
- An IAM user with access to Amazon Redshift ...
