Is it safe to modify autovacuum settings for tables in the TeamCity database

Question

The shared RDS PostgreSQL database instance used for the TeamCity SaaS product and other services experienced performance issues. The disk IOPS reached 99% utilization prompted by:

Is it safe to modify autovacuum settings for teamcity.public.test_info table in the TeamCity database?

Answer

• The development team confirmed that modifying autovacuum settings for tables in the TeamCity database is safe and won't impact product functionality.

ALTER TABLE teamcity.public.test_info
SET (autovacuum_vacuum_threshold = X, autovacuum_vacuum_scale_factor = 0);