Amazon Redshift is a fast, fully managed, petabyte-scale Data Warehouse (DWH) solution. It is a columnar Database and facilitates massive parallel processing (MPP). In any DWH solution, we always have facts, Dimensions, Xref, etc. types of datasets which vary significantly in size. Hence, It is not wise to use default redshift setting for all sizes of datasets.
To design an efficient redshift based DWH solution one need to be aware of various Static and dynamic variables which control the size and performance of the environment.