Add some indexes

This is from reading the slow query log on data.guix.gnu.org.

1 files changed, 13 insertions, 0 deletions

diff --git a/sqitch/deploy/some_indexes.sql b/sqitch/deploy/some_indexes.sql
new file mode 100644
index 0000000..d07edbf
--- /dev/null
+++ b/sqitch/deploy/some_indexes.sql
@@ -0,0 +1,13 @@
+-- Deploy guix-data-service:some_indexes to pg
+
+BEGIN;
+
+CREATE INDEX nar_urls_nar_id ON nar_urls (nar_id);
+
+CREATE INDEX load_new_guix_revision_jobs_unprocessed
+  ON load_new_guix_revision_jobs (id) WHERE succeeded_at IS NULL;
+
+CREATE INDEX guix_revision_lint_warnings_guix_revision_id
+  ON guix_revision_lint_warnings (guix_revision_id);
+
+COMMIT;