AWS Redshift – Choosing a Column Compression Type

Choosing a Column Compression Type

• Columnar compression delivers increased performance and lower cost

• The “COPY” command automatically analyzes and compresses data when loading into empty tables

• The “ANALYZE COMPRESSION” command checks existing tables and proposes optimal compression algorithms for each column

• You can query system tables for storage utilization

• You cannot change the compression encoding for a column after the table is created

• You can specify the encoding for a column when it is added to a table using the ALTER TABLE command

Be Careful When Compressing Your Sort Keys

Zone maps store min/max per block

• After we know which block(s) contain the range, we know which row offsets to scan

• Highly compressed sort keys means many rows per block

• You’ll scan more data blocks than you need

• If your sort keys compress significantly more than your data columns, you may want to skip compression of sortkey column(s)

• Check SVV_TABLE_INFO(skew_sortkey1)

0 views0 comments

Recent Posts

See All

How to Install & Configure AWSCLI on macOS ?

Users using macOS can follow the below command and steps to install the latest version of AWS CLI.The user should have sudo access to execute the below command. ​​For the latest version of the AWS CLI