Amazon Redshift VACUUM runs per schema or per database?

2.7k views Asked by At

Does VACUUM; with no other arguments run per database or per current schema on amazon redshift?

The reason I am asking this is because when VACUUM completes on one schema and I change the default schema, and run it again, it takes a whole hour to complete.

1

There are 1 answers

0
Walter Gillett On

VACUUM with no arguments runs on the entire database. See the Amazon Redshift VACUUM doc: "Reclaims space and resorts rows in either a specified table or all tables in the current database.".