[dak/master 13/16] add indexes to make override trigger fast
Signed-off-by: Mike O'Connor <stew@dhcp-101.dfw1.kickstart.lan>
---
dak/dakdb/update23.py | 4 ++++
1 files changed, 4 insertions(+), 0 deletions(-)
diff --git a/dak/dakdb/update23.py b/dak/dakdb/update23.py
index 708011c..5fa8a64 100644
--- a/dak/dakdb/update23.py
+++ b/dak/dakdb/update23.py
@@ -227,6 +227,10 @@ $$ LANGUAGE plpythonu VOLATILE SECURITY DEFINER;
AFTER UPDATE ON override
FOR EACH ROW EXECUTE PROCEDURE update_contents_for_override();""")
+
+ c.execute( "CREATE INDEX ind_deb_contents_name ON deb_contents(package);");
+ c.execute( "CREATE INDEX ind_udeb_contents_name ON udeb_contents(package);");
+
self.db.commit()
except psycopg2.ProgrammingError, msg:
--
1.6.5
Reply to: