We want to clean up some dead tuples from tables in our application PostgreSql RDS instance. So we are planning to run "Vacuum" command (not Vacuum full) on live DB after taking a Snapshot. Does this have any impact on the application? Do we need to have an application downtime to carry out this activity?
Option 1: Vacuum all the tables in one go.
Option 2: Vacuum individual tables with a gap of few seconds.