Lower the default PostgreSQL parameters for “autovacuum” in large-scale ImageMaster installations to improve performance. Ideal values can only be found by an investigation of the custom environment. For example, in one installation with several millions of documents in the archive storage it was observed that the following decrease was suitable:
autovacuum_vacuum_scale_factor = 0.02 (default: 0.2)
autovacuum_analyze_scale_factor = 0.01 (default: 0.1)
For more information and description of the parameters see [PgSQL Autovacuum Config].