Bug #17586

Weblate: evaluate the need for tuning PostgreSQL vacuuming

Added by zen 2020-04-03 10:41:21 . Updated 2020-04-03 10:43:15 .

Status:
Confirmed
Priority:
Normal
Assignee:
Sysadmins
Category:
Infrastructure
Target version:
Start date:
Due date:
% Done:

0%

Feature Branch:
Type of work:
Sysadmin
Blueprint:

Starter:
Affected tool:
Translation Platform
Deliverable for:

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