From 1a0c5599ebd8b2870b2c7aef3ec6797a4c203cd2 Mon Sep 17 00:00:00 2001 From: Christopher Baines Date: Mon, 28 Nov 2022 11:36:12 +0000 Subject: Do derivation inputs and outputs housekeeping at the end of each job This should help with query performance, as the recursive queries using derivation_inputs and derivation_outputs are particularly sensitive to the n_distinct values for these tables. --- guix-data-service/jobs/load-new-guix-revision.scm | 16 ++++++++++++++++ 1 file changed, 16 insertions(+) (limited to 'guix-data-service/jobs/load-new-guix-revision.scm') diff --git a/guix-data-service/jobs/load-new-guix-revision.scm b/guix-data-service/jobs/load-new-guix-revision.scm index f60eaad..c1c27af 100644 --- a/guix-data-service/jobs/load-new-guix-revision.scm +++ b/guix-data-service/jobs/load-new-guix-revision.scm @@ -2142,6 +2142,22 @@ SKIP LOCKED") "vacuuming package derivations by guix revision range table" (vacuum-package-derivations-table conn)) + (with-time-logging + "update-derivation-inputs-statistics" + (update-derivation-inputs-statistics conn)) + + (with-time-logging + "vacuum-derivation-inputs-table" + (vacuum-derivation-inputs-table conn)) + + (with-time-logging + "update-derivation-outputs-statistics" + (update-derivation-outputs-statistics conn)) + + (with-time-logging + "vacuum-derivation-outputs-table" + (vacuum-derivation-outputs-table conn)) + #t) (begin (exec-query conn "ROLLBACK") -- cgit v1.2.3