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.
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.".