Reduced file journal index bloat by removing indexes that would only be

used in rare cases and where we'd almost always only be interested in very
recent entries only (timestamp is indexed). This should decrease insertion
time a bit.

Change-Id: Idb33ee3229315c44b764a8ed476afe8760f5595c

diff --git a/maintenance/archives/patch-filejournal.sql b/maintenance/archives/patch-filejournal.sql
index b7a7d09..8c2f6b9 100644 (file)
--- a/maintenance/archives/patch-filejournal.sql
+++ b/maintenance/archives/patch-filejournal.sql
@@ -19,6 +19,4 @@ CREATE TABLE /*_*/filejournal (
 );
 
 CREATE INDEX /*i*/fj_batch_id ON /*_*/filejournal (fj_batch_uuid,fj_id);
-CREATE INDEX /*i*/fj_path_id ON /*_*/filejournal (fj_path_sha1,fj_id);
-CREATE INDEX /*i*/fj_new_sha1 ON /*_*/filejournal (fj_new_sha1,fj_id);
 CREATE INDEX /*i*/fj_timestamp ON /*_*/filejournal (fj_timestamp);