Release: Amazon Redshift on 2016-03-17

Release Notes>Amazon Redshift>Release: Amazon Redshift on 2016 03 17
This release of Amazon Redshift adds more control over when VACUUM resorts tables and delivers improved performance when loading data in sort key order. Also, new columns have been added to STL_CONNECTION_LOG.

Details

Release Date: March 18, 2016 12:23 AM GMT
Created On: March 18, 2016 12:15 AM GMT
Last Updated: March 18, 2016 12:24 AM GMT

New Features

Feature Description
VACUUM sort threshold

The VACUUM command now skips the sort phase for any table where more than 95 percent of the table's rows are already sorted. You can change the default sort threshold for a single table when you run the VACUUM command.

Improved sorting during COPY

When you load data in sort key order, COPY now automatically adds new rows to the table's sorted region. For more information, see Loading Your Data in Sort Key Order.

New columns in STL_CONNECTION_LOG

The STL_CONNECTION_LOG system table has three new columns. If you routinely load audit logs to an Amazon Redshift table, you will need to add the following new columns to the target table: sslversion, sslcipher, and mtu.

Documentation

For a summary of these new features and other documentation changes, see Document History in the Amazon Redshift Database Developer Guide and the Amazon Redshift Cluster Management Guide.

©2017, Amazon Web Services, Inc. or its affiliates. All rights reserved.