Posted On: Jan 20, 2017

Amazon Redshift now supports Zstandard (ZSTD) column compression encoding, which delivers better data compression thereby reducing the amount of storage and I/O needed. With the addition of ZSTD, Amazon Redshift now offers seven compression encodings to choose from depending on your dataset.

With this release, we are also adding two new aggregate functions. Previously available as window functions, PERCENTILE_CONT and MEDIAN are now also available as aggregate functions.