Amazon Redshift now supports elastic resize scheduling
The Amazon Redshift cluster elastic resize operation can now be automated using a scheduler that allows you to automatically resize clusters to accommodate changes in workloads that occur on a regular basis. For example, you can now automatically expand a cluster to accommodate heavier workloads as well as shrink a cluster to accommodate lighter workloads at specific times of day. This will allow you to automate cluster resizing to balance price and performance when using Redshift.
Source:: Amazon AWS