Bug reference: 16620 Logged by: Max Vikharev Email address: bm.kinder@gmail.com PostgreSQL version: 12.3 Operating system: Linux Description:
Hi,
There is a cluster with 50 databases. The sizes of tables are very different, from megabytes to terabytes.
We have been successfully used the aggressive autovacuum for a long time. After upgrade from 10 to 12.3 we've noticed that autovacuum always process relations from one database but does not reach others.
I have logs (log_autovacuum_min_duration = 0) that confirms that only single database is constantly being autovacuumed. Within pg_stat_user_tables i see that last time autovacuum / autoanalyze for other databases happened in the same day when "vacuum to prevent wraparound" worked.
Please help to investigate the problem. Why my relations does not processed and how can i fix it.