HomeSoftware Heritage

postgresql: Increase some timeouts to get origin visits

Description

postgresql: Increase some timeouts to get origin visits

Even if missing index to speedup origin visit queries has
been added to replica database, the configured timeouts for
origin_visit_get_with_statuses and origin_visit_find_by_date
were still too low to avoid query timeouts in production.

After performing some tests locally, bumping them to 2000ms
makes the timeouts go away.

Related to T4386

Details

Provenance
anlambertAuthored on Jul 13 2022, 4:44 PM
anlambertPushed on Jul 13 2022, 6:30 PM
Differential Revision
D8124: postgresql: Increase some timeouts to get origin visits
Parents
rDSTOcfc867999d9d: backfill: Add support for directories with duplicated entries
Branches
Unknown
Tags
Unknown
References
tag: v1.4.2
Tasks
Restricted Maniphest Task
Build Status
Buildable 30429
Build 47568: test-and-buildJenkins console · Jenkins