VACUUM all tables after mass-insert

[m_librarian.git] / m_librarian / inp.py

diff --git a/m_librarian/inp.py b/m_librarian/inp.py
index db0a3d834baf41c5bb7a195a12047d2ceb07c3df..e99800a18e13d4ec3fc6ffcefa6915e5699b9642 100644 (file)
--- a/m_librarian/inp.py
+++ b/m_librarian/inp.py
@@ -68,3 +68,7 @@ def import_inpx(path):
         inp = inpx.open(name)
         sqlhub.doInTransaction(import_inp, archive + '.zip', inp)
         inp.close()
+    connection = sqlhub.processConnection
+    if connection.dbName in ('postgres', 'sqlite'):
+        for table in Author, Book, Extension, Genre, Language:
+            connection.query("VACUUM %s" % table.sqlmeta.table)