From 8066bbf3588ed401f8c689f4ebe76e59cba2de2c Mon Sep 17 00:00:00 2001 From: Michael Tremer Date: Sun, 22 Oct 2017 12:42:33 +0100 Subject: [PATCH] db: Cluster filelists table by package ID Signed-off-by: Michael Tremer --- src/database.sql | 16 +++++++++------- 1 file changed, 9 insertions(+), 7 deletions(-) diff --git a/src/database.sql b/src/database.sql index 01a1331..5f7c572 100644 --- a/src/database.sql +++ b/src/database.sql @@ -2637,6 +2637,15 @@ CREATE UNIQUE INDEX distributions_sname ON distributions USING btree (sname) WHE CREATE INDEX filelists_name ON filelists USING btree (name); +-- +-- Name: filelists_pkg_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace: +-- + +CREATE INDEX filelists_pkg_id ON filelists USING btree (pkg_id); + +ALTER TABLE filelists CLUSTER ON filelists_pkg_id; + + -- -- Name: idx_2197982_builder_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace: -- @@ -2693,13 +2702,6 @@ CREATE INDEX idx_2198018_build_id ON builds_comments USING btree (build_id); CREATE INDEX idx_2198018_user_id ON builds_comments USING btree (user_id); --- --- Name: idx_2198052_pkg_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace: --- - -CREATE INDEX idx_2198052_pkg_id ON filelists USING btree (pkg_id); - - -- -- Name: idx_2198063_build_id; Type: INDEX; Schema: public; Owner: pakfire; Tablespace: -- -- 2.47.3