From 1b64c8e3ac85284f8ecac62881390a402116898d Mon Sep 17 00:00:00 2001 From: Mike O'Connor Date: Sat, 31 Oct 2009 13:47:28 +0000 Subject: [PATCH] add indexes to make override trigger fast Signed-off-by: Mike O'Connor --- dak/dakdb/update23.py | 4 ++++ 1 file changed, 4 insertions(+) diff --git a/dak/dakdb/update23.py b/dak/dakdb/update23.py index 708011cf..5fa8a643 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: -- 2.39.5