Redshift :STV_PARTITIONS

Hi All, I was doing some reading related to stv_partitions. (https://docs.aws.amazon.com/redshift/latest/dg/r_STV_PARTITIONS.html). The example in the link states that the pct_used is evenly distributed across the disk partitions.

I tired the same against the instance I work and see that we have 8 node cluster with 2 disk partions per node. Within each node, only one disk space per node has pct used of 70 while the other show it as 0. Is this something we should be concerned about?

トピック

データベース分析

タグ

データベース Amazon Redshift

言語

English

AWS-User-8821482

質問済み 2年前226ビュー

1回答

新しい順
投票が多い順
コメントが多い順

承認された回答

Not necessarily something to be concerned about, but it's worth digging into. Take a look at the query provided here: https://docs.aws.amazon.com/redshift/latest/dg/diagnostic-queries-for-query-tuning.html#identify-tables-with-data-skew-or-unsorted-rows

This will help identify tables that have uneven distribution or a high percentage of rows unsorted and the description on that page tells you the thresholds to look for in your query results.

Don_D

回答済み 2年前

エキスパート

Fabrizio@AWS

レビュー済み 2年前

AWS-User-8821482
2年前
Thank you @Don_D. I will review your suggestions and revert back in case I need your inputs.

Redshift :STV_PARTITIONS

関連するコンテンツ