Does Panoply manage the Redshift vacuum process?

Yes, Panoply manages the vacuuming. Vacuuming is the process of permanently deleting rows that are marked for deletion within your data warehouse. When running a DELETE query, it will not trigger an automatic vacuuming. Instead, it will mark the rows as deleted so they will not return when querying the table or affect any ingestion process.

Vacuuming occurs automatically with Panoply data warehouses at least as often as once per day. Before the vacuum process completes, you might see inflation in your data storage size based on how many rows marked for deletion remain in the tables.