Free disk space unchanged after classic resize

0

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 ago293 views
1 Answer
0

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: https://aws.amazon.com/premiumsupport/knowledge-center/redshift-cluster-storage-space/

AWS
Sain_D
answered 2 years ago
AWS
EXPERT
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