#1944 analyze/vacuum all affected tables
Merged 2 years ago by tkopecek. Opened 2 years ago by tkopecek.
tkopecek/koji issue1941  into  master

file modified
+3 -1
@@ -101,6 +101,7 @@ 

      cursor.execute("DELETE FROM task WHERE id IN (SELECT task_id FROM temp_scratch_tasks)")

  

      if vacuum:

+         cursor.execute("VACUUM ANALYZE standard_buildroot")

          cursor.execute("VACUUM ANALYZE task")

  

  
@@ -116,7 +117,8 @@ 

          cursor.execute("DELETE FROM buildroot_listing WHERE buildroot_id IN (SELECT id %s)" % q)

          cursor.execute("DELETE " + q)

          if vacuum:

-             cursor.execute("VACUUM ANALYZE build_reservations")

+             cursor.execute("VACUUM ANALYZE buildroot_listing")

+             cursor.execute("VACUUM ANALYZE buildroot")

  

  

  if __name__ == "__main__":

Metadata Update from @tkopecek:
- Pull-request tagged with: testing-ready

2 years ago

Metadata Update from @tkopecek:
- Pull-request untagged with: testing-ready
- Pull-request tagged with: no_qe

2 years ago

Commit 1b951f1 fixes this pull-request

Pull-Request has been merged by tkopecek

2 years ago
Metadata