Free disk space unchanged after classic resize


Hi - we had a Redshift cluster with 6 dc2.large nodes, and percent disk space used at the time was > 90%. We completed a classic resize to 8 nodes a few days ago. However, the percent disk space used remained basically unchanged after the resize. Is it an error in reporting or expected behavior?

asked 2 years ago318 views
1 Answer

One scenario that could result in the behavior described is if there is a large number of small tables that have a distribution style of EVEN/ KEY. If that is the case, then changing the distribution style for these smaller tables to ALL may help reclaim some space. Each table on Amazon Redshift has a minimum table size and this varies based on the number of columns, the number and type of the nodes in the cluster and the distribution style. The below link has more information on the topic and illustrates how this works using a few examples:

answered 2 years ago
reviewed 2 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions