Author: justi9 Date: 2010-07-12 13:49:08 -0400 (Mon, 12 Jul 2010) New Revision: 4103 Modified: mgmt/newdata/mint/python/mint/vacuum.py Log: Analyze when we vacuum; vacuum every hour Modified: mgmt/newdata/mint/python/mint/vacuum.py =================================================================== --- mgmt/newdata/mint/python/mint/vacuum.py 2010-07-11 23:16:10 UTC (rev 4102) +++ mgmt/newdata/mint/python/mint/vacuum.py 2010-07-12 17:49:08 UTC (rev 4103) @@ -12,7 +12,7 @@ up = VacuumUpdate(self.app.model) self.app.update_thread.enqueue(up) - sleep(60 * 60 * 10) + sleep(60 * 60) class VacuumUpdate(Update): def do_process(self, cursor, stats): @@ -35,7 +35,7 @@ log.info("Vacuumed tables") def vacuum(self, cursor, cls): - sql = "vacuum verbose %s" + sql = "vacuum analyze verbose %s" cursor.execute(sql % cls.sql_table.identifier) cursor.execute(sql % cls.sql_samples_table.identifier)