Weblate: evaluate the need for tuning PostgreSQL vacuuming
I’ve seen proxy timeouts when waiting for Weblate operations at the same time that PostgreSQL was running its autovaccum daemon.
From the documentation:
PostgreSQL databases require periodic maintenance known as vacuuming. For many installations, it is sufficient to let vacuuming be performed by the autovacuum daemon, which is described in Section 23.1.5. You might need to adjust the autovacuuming parameters described there to obtain best results for your situation. Some database administrators will want to supplement or replace the daemon's activities with manually-managed VACUUM commands, which typically are executed according to a schedule by cron or Task Scheduler scripts. To set up manually-managed vacuuming properly, it is essential to understand the issues discussed in the next few subsections. Administrators who rely on autovacuuming may still wish to skim this material to help them understand and adjust autovacuuming.
We should check whether we need to tune the autovacuum daemon or come up with an alternate way to do this periodic maintenance.