Bug #17586
Weblate: evaluate the need for tuning PostgreSQL vacuuming
Start date:
Due date:
% Done:
0%
Description
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.
Subtasks
History
#1 Updated by zen 2020-04-03 10:43:15
- Subject changed from Weblate: evaluate the need for tuning PosgreSQL vacuuming to Weblate: evaluate the need for tuning PostgreSQL vacuuming