4

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.

Martin Taleski
  • 6,033
  • 10
  • 40
  • 78

1 Answers1

2

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

Walter Gillett
  • 371
  • 1
  • 2
  • 9