AWS re:Post을(를) 사용하면 다음에 동의하게 됩니다. AWS re:Post 이용 약관
AWS re:Postre:Post

Redshift :STV_PARTITIONS

0

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?

주제
데이터베이스분석
태그
데이터베이스아마존 Redshift
언어
English
AWS-User-8821482
질문됨 2년 전226회 조회
1개 답변
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.

AWS
Don_D
답변함 2년 전
AWS
전문가
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.

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

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

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

관련 콘텐츠