Vacuums in Redshift and new Redshift Enhancements


#1

Hi,

we Vacuum and Analyze our Tables from time to time, even if we just COPY data in. For now I do it manually every 3 - 6 months.
With the update linked at the end this shouldn’t be nessecary anymore or very rarely right? I’m also interested in how often other people vacuum their tables for example the atomic.events that is append-only so there are no updated or deletes.

https://forums.aws.amazon.com/ann.jspa?annID=4157
*Data loading enhancement. If you load your data in sort key order
using a compound sort key with only one sort column, you might now
reduce or even eliminate the need to vacuum as the COPY command
automatically adds new rows in sort order to the table’s sorted region


#2

Hey @tclass - thanks for sharing. That should indeed remove the need to vacuum the atomic tables as they are append-only.