VACUUM tables

[alok87]

Tables in Redshift needs to be vacuumed for peak performance. Auto VACUUM might not be helpful always.
https://docs.aws.amazon.com/redshift/latest/dg/r_VACUUM_command.html
https://docs.aws.amazon.com/redshift/latest/dg/t_Reclaiming_storage_space202.html
https://docs.aws.amazon.com/redshift/latest/dg/r_SVV_TABLE_INFO.html

select "table", unsorted,vacuum_sort_benefit from svv_table_info order by 2 desc;

Can operator perform nightly vacuums on tables which have many unsorted and uncleaned data?

AWS does provide auto vacuuming, but we knowing the time of load and time when we want peak performance we can enable vacuuming from the operator.

[alok87]

p3 since aws already does it well.