- 최신
- 최다 투표
- 가장 많은 댓글
Redshift checks the status of AUTO distributed tables periodically and converts the distribution type as needed. https://docs.aws.amazon.com/redshift/latest/dg/c_choosing_dist_sort.html
AUTO distribution
With AUTO distribution, Amazon Redshift assigns an optimal distribution style based on the size of the table data. For example, Amazon Redshift initially assigns ALL distribution to a small table, then changes to EVEN distribution when the table grows larger. When a table is changed from ALL to EVEN distribution, storage utilization might change slightly. The change in distribution occurs in the background, in a few seconds. Amazon Redshift never changes the distribution style from EVEN to ALL. To view the distribution style applied to a table, query the PG_CLASS_INFO system catalog view. For more information, see Viewing Distribution Styles. If you don't specify a distribution style with the CREATE TABLE statement, Amazon Redshift applies AUTO distribution.
I have no idea, but it makes me think of VACUUM checking to see if it should skip a table or not (because it's already sorted enough).
관련 콘텐츠
- AWS 공식업데이트됨 3년 전