Amazon Redshift service provides a petabyte-scale data warehouse that makes for rapid, cost-effective data analysis. It uses columnar compression to raise I/O performance and the storage capacity of their nodes.
AWS has just upgraded Amazon Redshift with four new improvements:
- Zstandard Compression Algorithm – affords high compression ratio, reducing disk space by 65%. Zstandard can also be applied to many data types: SMALLINT, INTEGER, BIGINT, DECIMAL, REAL, DOUBLE PRECISION, BOOLEAN, CHAR, VARCHAR, DATE, TIMESTAMP and TIMESTAMPTZ.
- Improved Automation of Compression – Better automation of compression by commands such as CREATE TABLE AS, CREATE TABLE or ALTER TABLE ADD COLUMN. Amazon Redshift automatically selects a default compression for the columns, done only when it is estimated to reduce disk space without lowering performance. This will provide up to 40% reduction in disk space.
- Enhanced Analyze Compression Command – this can better determine opportunities to compress data and drive performance.
- Optimized internal on-disk data structure – provides an average of 7% reduction in disk space usage.
Based on these improvements, you may reduce the data sets by up to four times.
Ready to make your move into the cloud? Contact our AWS specialists today at PolarSeven.