>> accelerate >> your cloud adoption
Call Us On: 1300 659 575

Amazon Redshift Data Compression Up 400%

Amazon RedShift Data compressionAmazon 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.

 

Leave a Reply

About PolarSeven

PolarSeven’s vision is to be a customer centric, Amazon Web Services consultancy, where cloud computing is seen as a key enabler to our customers needs and challenges. “We help our customers achieve amazing things.....”

Contact Us

  • This field is for validation purposes and should be left unchanged.