action #159396
Updated by okurz 8 months ago
## Observation
https://stats.openqa-monitor.qa.suse.de/d/WebuiDb/webui-summary?orgId=1&viewPanel=78&from=now-24h&to=now
B0=15.654104274
Notably the graph says 15.7 at the time of the alert e.g. 00:36, the second highest is 3.7s a couple of hours earlier and otherwise around the 200ms mark (note the difference in units). There seems to be no obvious fallout or other alerts coinciding?
## Suggestions
* Investigate what jobs were running around the time of the alert
* Check if relevant changes e.g. changes to salt/worker slots had an impact here
* pg_dump might slow down overall performance. Consider options from
* https://serverfault.com/questions/349221/how-to-make-pg-dump-less-resource-greedy
* https://www.postgresql.org/docs/current/performance-tips.html
* https://www.linkedin.com/pulse/how-speed-up-pgdump-when-dumping-large-postgres-nikolay-samokhvalov/
* try out in particular the `-j` option on pg_dump
Back