It isn't clear if auto vacuum is running in rds. Thanks!

  • 5
    Run SHOW autovacuum;. Or enable autovacuum logging and check the logs. RDS certainly does require vacuum, but I'd be surprised if it wasn't doing pretty aggressive autovacuuming. – Craig Ringer Jul 9 '14 at 3:16

Run this query to show if/when your tables were last vacuumed.

SELECT * FROM pg_stat_all_tables;

A table won't be vacuumed until the insert/update/delete threshold is reached, which is 20%.

You can tweak the setting in RDS by creating a new DB Parameter Group and change the setting you want.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.