- Newest
- Most votes
- Most comments
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).
Relevant content
- Accepted Answerasked 2 months ago
- Accepted Answerasked 4 years ago
- asked a year ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 3 months ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated 2 months ago