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?

질문됨 2년 전285회 조회
1개 답변
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
답변함 2년 전
AWS
전문가
검토됨 2년 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠