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?

posta 2 anni fa285 visualizzazioni
1 Risposta
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
con risposta 2 anni fa
AWS
ESPERTO
verificato 2 anni fa

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande