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)